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 steven

    to
    15
    20
    33
    boy
    white
    journal
    20
    11
    28
    girl
    yellow
    steven

    Any 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


Log in to reply