I have too many records which ending as below :
en-US|||||
But i wanted them to be replace to new line let say
en-US
newline
Note text en and US are different in each records, the only item needed to be kept is "-". Please advise.
I have too many records which ending as below :
en-US|||||
But i wanted them to be replace to new line let say
en-US
newline
Note text en and US are different in each records, the only item needed to be kept is "-". Please advise.
Press Ctrl+H (Find & Replace).
Use those settings:
Search mode: Extended
Find what: |||||
Replace with: \n
Replace.
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. https://stackoverflow.com/questions/4398613/notepad-newline-in-regex