Visual Studio append text to end of lines using find/replace with end line regular expression ($)

Question

I am trying to append some text (e.g. "Fish") to the end of every line in a file using Visual Studio or SQL Server Management Studio using the following settings in the find/replace dialog:

• Find what: $
• Replace with: Fish
• Use Regular expressions: Checked

This mostly does the job, but for a handful of lines it not only appends "Fish" to the end of the line it also puts it at the beginning of the line. I can't discern any pattern to this behaviour it seems to be almost random, with the larger the file the more lines tending to go wrong.

A similar find/replace with ^ (to put text at the beginning of the line) works with no problem.

Anybody know why this is happening? And also, are there any better suggestions for achieving what I want to?

Answer 1

This works in Visual Studio 2012 and 2015:

Find: \r 
Replace: Fish\r

Make sure you tick 'Use Regular Expressions' checkbox: