How to add Prefix to Every Field with Notepad ++

If your System doesn't support heavy applications or editors which are required for data editing or development purposes then the next best thing after notepad is notepad ++. It contains pretty cool features and one of them is adding/appending similar data to front of string in every row.  This is best show via example.

So let's say you have a file with numbers and you want to separate numbers with inverted commas like ' ' or let's say by ' , ' , then we can do it in following way.



Select the numbers and then Select "Replace" or Ctrl + H.

Now make sure that the radio button with option "Regular Expression" is selected.

Now put ' ^ ' in the text box with "Find what" option.



And put character name you want to replace it with in "Replace with" text box option, which is " ' " in our case.

Now Click on "Replace All" options and Bingo !! You are done. " ' " character is added in front of every string.  You can use this method to replace it with any string.



Also in similar fashion, if you want to append any character or string in the end of every row, you can also do that in similar way. Instead of  ' ^ ' in the "Find what" option put ' $ ' and click "Replace All" and you will get the results as below. 



Cheers !! 

Read More