How do I search for a ', ' and replace with ', '<CR><LF> in SQL Server Management Studio's editor

Question

I have a long query that I'd like to replace the , with a carriage return to put all the fields on their own line but I can't figure out how to do it in the editor. It wont be fool proof, but better than doing it by hand.

Answer 1

CTRL+H

Find what: ', ' (No Quotes)
Replace With: ', \n' (No Quotes)

Expand the Find options and tick the Use Regular Expressions checkbox.

Answer 2

do a find/replace. you want to find a , and replace with a ,\n (new line). to use \n check the box at the bottom called "Use:" and then from the dropdown choose "Regular expressions".

Answer 3

Check the 'Use regular expressions', search ro \, and replace it with ,\n