convert multiple columns to rows using notepad
-
Greetings friends, please how could I convert to rows using notepad?
15 20 33 boy white journal
20 11 28 girl yellow stevento
15
20
33
boy
white
journal
20
11
28
girl
yellow
stevenAny friends idea?
thanks you -
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:
Find What:\h
Replace with:\r\n
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.
Terry