I have a pipe delimited string of NAME|VALUE pairs looking something like this..


What I want to do is to replace every second instance of | with a new line so that I have something like this..


My issue isn't the new-line, as I know I can use \r\n for that, but rather the regex part that only replaces every second instance of |.

3 Answers 3


Find: ([^\|]*\|[^\|]*)\|
Replace to: \1\n

  • 1
    That doesn't work.
    – DavidPostill
    Aug 19, 2015 at 8:56
  • 1
    I tried this, but this just adds a new line without actually splitting the string at the |'s Aug 19, 2015 at 8:56
  • I've corrected and tried, it works for me now. Sorry for the previous version. Aug 19, 2015 at 9:00
  • @nixda: it was working for me also before your correction, | isn't a special character in that situation, it doesn't need to be escaped Aug 19, 2015 at 9:04
  • In my Notepad version (6.6.9) they need to be escaped. Don't know what to tell. Its just not working without
    – nixda
    Aug 19, 2015 at 9:06

I want to replace every second instance of | with a new line

  • Menu "Search" > "Replace" (or Ctrl + H)

  • Set "Find what" to (.*?\|.*?)[\|]

  • Set "Replace with" to \1\r\n

  • Enable "Regular expression"

  • Click "Replace All"

    enter image description here






  • The above assumes you are editing a text file with Windows EOLs, \r\n.

  • If you are using files with different EOLs you can convert them to Windows EOLs using Menu "Edit" > "EOL Conversion".

  • If you aren't working with Windows EOL, and you don't wish to convert them, use the following instead:

    • Use \n instead of \r\n for Unix/OS X EOLs

    • Use \r instead of \r\n for Mac OS (up to version 9) EOLs

Further reading

  • The regex provided is rather questionable: the first .*?, as a non-greedy match, will never match anything because there is nothing to its left to anchor it. It effectively becomes a no-op.
    – Bob
    Jan 3, 2018 at 3:45

This attempts to show how to replace every Nth character with a newline without copy-pasting parts of the sequence. In such case a number is needed to tell the engine how many repetitions are expected. In this example I want to replace every 13th occurrence of character @ with a newline. You can see 12 (13-1) repetitions of non-capturing group plus remaining text before the 13th character @ in one captured group. Then there's matched, but not captured 13th character @ which will be replaced with \r\n.

Find what: ((?:.*?\@){12}.*?)\@
Replace with: $1\r\n
Check Wrap around
Search Mode = Regular expression
Replace All

The character @ should be changed to your actual separator character (it's repeated two times in the pattern). E.g., if your separator is |, your pattern would be ((?:.*?\|){12}.*?)\|
Also, the number 12 should be replaced with your value (N-1).

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .