Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have too many records which ending as below :


But i wanted them to be replace to new line let say



Note text en and US are different in each records, the only item needed to be kept is "-". Please advise.

share|improve this question
The only thing method i tried is replace with : \n. What do i have to input in "Find What : xx-xx||||" ? – Kenneth Lhv Sep 14 '12 at 5:34
up vote 6 down vote accepted
  1. Press Ctrl+H (Find & Replace).

  2. Use those settings:

    • Search mode: Extended

    • Find what: |||||

    • Replace with: \n

  3. Replace.

share|improve this answer

User regular expression to find [a-zA-Z][a-zA-Z]-[a-zA-Z][a-zA-Z]|||| and replace \n

in Notepad++ 6, PCRE (Perl Compatible Regular Expressions) is supported. Here is Ref.

We should also referece another stackoverflow question. Notepad++ newline in regex

share|improve this answer
Thanks swemon! Worked like a spell! – Kenneth Lhv Sep 14 '12 at 6:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.