?.?)) means find and select everything between the starting point and the 3rd comma and the \1\r\n means replace it with itself and a newline. So to insert a line break every third comma you just need to put your SQL into Notepad++, use TextFX Unwrap text option to get it all on a single line, sacrifice a chicken while dancing backwards around 13 tuples chanting “Chamberlin Boyce Codd” and enter the following in the Find / Replace dialog in Notepad++ – You could manually format it and then when you get another statement do it again and then jam a pen in your eyeball or you could use the dark and mysterious art of regular expressions. Imagine you have a SQL statement that looks like this – select ,īut it’s more like 65 fields with a preceding insert statement and proceeding group by clause and the editor you are using doesn’t support formatting in any useful way. Once your work is completed copy your text or close the window as your work gets saved automatically inside the tool. Use the extreme left sidebar to choose more options: Clone, View all, Upload, and Compose new. Thankfully with the help of every programmers best friend (Notepad++) and most programmers source of utter befuddlement (Regular Expressions) I was able to solve the issue easily. Start writing your text on the widescreen. I experienced just that issue not long ago trying to format TSQL to line break every 3rd comma.
0 kommentar(er)
