# Trying to match version number in SQL script with Text Find / Replace
**URL:** https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469
**Category:** Discussion
**Created:** [April 28, 2010, 7:42am UTC](https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469 "2010-04-28T07:42:06Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@jeremyjarrell](https://www.finalbuilder.com/forums/u/jeremyjarrell)
#### Post date: [April 28, 2010, 7:42am UTC](https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469/1 "2010-04-28T07:42:06Z")
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
---
### Author:  [@robert.wachtel](https://www.finalbuilder.com/forums/u/robert.wachtel)
#### Post date: [April 28, 2010, 7:47am UTC](https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469/2 "2010-04-28T07:47:11Z")
Have you tried it without the groups?
[code]\d+.\d+.\d+.\d+[/code]
(but then maybe you should better include the ’ to your pattern)
---
### Author:  [@jeremyjarrell](https://www.finalbuilder.com/forums/u/jeremyjarrell)
#### Post date: [April 28, 2010, 7:52am UTC](https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469/3 "2010-04-28T07:52:22Z")
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
---
### Author:  [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [April 28, 2010, 10:55am UTC](https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469/4 "2010-04-28T10:55:49Z")
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.
---
### Author:  [@jeremyjarrell](https://www.finalbuilder.com/forums/u/jeremyjarrell)
#### Post date: [April 29, 2010, 12:46pm UTC](https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469/5 "2010-04-29T12:46:27Z")
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
---
### Author:  [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [April 29, 2010, 10:29am UTC](https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469/6 "2010-04-29T10:29:41Z")
Hi Jeremy,
Could you please send in the text file and your FinalBuilder project to support [at] [finalbuilder.com](http://finalbuilder.com) and we’ll see if we can work out why it’s not working.
Regards,
Paul.
---
### Author:  [@jeremyjarrell](https://www.finalbuilder.com/forums/u/jeremyjarrell)
#### Post date: [April 30, 2010, 2:26am UTC](https://www.finalbuilder.com/forums/t/trying-to-match-version-number-in-sql-script-with-text-find-replace/1469/7 "2010-04-30T02:26:20Z")
Hi Paul,
I’ve sent the email from jjarrell [at] [matrixformedia.com](http://matrixformedia.com). Thanks for your continued help, I’m looking forward to your response.
Jeremy