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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login