convert multiple columns to rows using notepad
yuly pmem last edited by yuly pmem
Greetings friends, please how could I convert to rows using notepad?
15 20 33 boy white journal
20 11 28 girl yellow steven
Any friends idea?
Terry R last edited by Terry R
This is very simple. I’m surprised you have not already figured it out. Basically (from your sample) you want to change all spaces to a carriage return/line feed. So each word will be on a separate line.
The regex is:
As this is a regular expression you need the search mode in “regular expression” mode and have wrap around ticked.
So the \h is a horizontal whitespace character: tab or Unicode space separator.
The \r and \n are the carriage return and line feed characters.
As a suggestion, read up on regexes by starting with:
https://notepad-plus-plus.org/community/topic/15765/faq-desk-where-to-find-regex-documentation in our FAQ and also by using a regex tester (there are a few on the web) including the one mentioned in that post.
It’s nice to see posters trying to find the solution themselves (especially one as simple as this one), then if in doubt or needing guidance, to come to the forum and show what they’ve tried and their samples.