I assume your conclusion is right. Depending on your data, you might even solve it with an easier regex:

s/\)$/\);/;   # replace an ) at the end of the line with an );
[download]

HTH, Rata