I am using SQL Server Management Studio and need to find and replace some very large database data in a query.
The format I am needing to remove is:
VALUES (XXX,
As an example:
VALUES (25,
VALUES (101,
VALUES (55,
I can not seem to find a regex in order to do this in SQL find and replace. And I am not very good at trying to make a regex match pattern....
Any help would be great!
Update
Sorry what I meant is that I am using the Find and replace under the Edit menu:
Without more detail about exactly how you're using this regex it is difficult to be sure if this will help or not, but a regex which would match any of those lines would be:
VALUES \([0-9]+,
The 'VALUES (' bit should just match that as a string (the backslash before the open bracket is so your regex engine knows it is part of the string, and not part of the instructions about searching). The [0-9] bit says that any digit from 0-9 is valid, and the + bit says there needs to be at least one digit. You might also want a ^ at the start to indicate it is the start of a line, depending on your use-case. Note that this will match any number of digits after the bracket, and before the final comma.
VALUES (XXX,with empty string