Tuesday, December 29, 2020

HOW TO - Replace CR LR in a TXT file

 q: The customer has a text file full of data, one value per row.  They want them all in a single row separated by a comma.

a: Using Notepad++, click the Paragraph icon in the toolbar (this shows CR and LF at the end of each line).  From the Menu click Search and Replace.  Find what: \r\n    replace with: ,       Then click Replace All.  done!



No comments:

Post a Comment