Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

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