Trying to match version number in SQL script with Text Find / Replace

FinalBuilder Discussion
1

Hello all,

I'm using the Text Find / Replace Action to update a version number in a SQL file.  The string I'm looking for in the file looks like...

INSERT INTO [dbo].[InstallationHistory] (
            [Version]
      ) VALUES (
             '1.4.22.15521'
      )

I'm trying to isolate the '1.4.22.15521' value so it can be updated with another value.  I'm using a regex match with the pattern

(\d+\.)(\d+\.)(\d+\.)(\d+)

which works find in testing in a text editor.  However, when I try to match with this same pattern in the Text Find / Replace Action with the "Match as regular expression" option checked I receive no matches.  I understand that Text Find / Replace doesn't support a full regex implementation, am I using something that's not supported?  If so, is there another way I can achieve my goal?

 

Thanks,

Jeremy

 

2

Have you tried it without the groups?

[code]\d+.\d+.\d+.\d+[/code]

(but then maybe you should better include the ’ to your pattern)

3

Hi Robert,

Thanks for the quick reply.  I've just tried the regex without the groups, both with and without the surrounding single quotes.  Unfortunately I still found no matches.

Thank you for trying, though.

Jeremy

4

Hi Jeremy,

Please make sure you’ve got the latest official build of FinalBuilder 6 installed as we updated the RegEx library that the action uses to one that is Perl RegEx compatible. Once that’s done you should be able to use the expression:

(\d+).(\d+).(\d+).(\d+)

Regards,
Paul.

5

Hi Paul,

Thanks for the response. I’ve updated to the latest build (6.3.0.2026) and tried both your RegEx as well as my original RegEx. Unfortunately I’m still not able to find the version number string in my file.

I’ve also tried finding simple strings in the file, such as the InstallationHistory string that specifies the table in question, and noticed that I cannot find those either. In fact, I seem unable to find any string in the file at all. Could there be something else preventing the action from correctly loading my file, perhaps if it is in use elsewhere in the system or if it is an unsupported encoding?

Thanks,
Jeremy

6

Hi Jeremy,

Could you please send in the text file and your FinalBuilder project to support [at] finalbuilder.com and we’ll see if we can work out why it’s not working.

Regards,
Paul.

7

Hi Paul,

I’ve sent the email from jjarrell [at] matrixformedia.com. Thanks for your continued help, I’m looking forward to your response.

Jeremy