Monday, December 09, 2019

Notepad++ replace space with a Line feed

I was given a text file that needed to be ran through excel for a word count pivot table.  The txt file I received was un-formatted and only spaces were the common search I could do.

In Notepad++ I searched for \s and replaced it with \n to produce a line per word.  This allowed me to import into excel for further analysis.

No comments: