I get a list of ID numbers in excel. I need to manually create a SQL script to insert these values.
I managed to get a list of values like below into notepad++.
(@FeatureID,1,'00000000000'), (@FeatureID,1,'00000000001'), (@FeatureID,1,'00000000002'),
Now I want to use notepad++ to add the insert statement on every 1000th line to complete the SQL script.
Problem: The regex gets to line 999 but does not go to the end of the line.
Question: How do I get to the end of every 999th line, replace the comma add a new line and insert the following insert statement:
INSERT INTO feat.FeatureValidatorValue (FeatureId, ValidatorId, Value) VALUES)