Community

could you show me how to keep column 2 and 3

i try this
Find what: (.*)\|(.*)\|(.*)
Replace with: \2\3

but | also remove i would like keep | after the column 2

Hi thanks for help i have the gmail data only now....but still not resolve my other problem


I try this replace \n by \n\n
result:
email@gmail.com:zip

email@gmail.com:zip

email@gmail.com:zip

email@gmail.com:zip

email@gmail.com:zip
====================================
and i need the data to be ...

Hi all....i'm Amy from belgian...

I'm new with textpad try to learn it before post here but i'm lost.
I have a txt file like this:

email:zipcode

aaaaaaaaaa@hotmail.de:90233
bbbbbbb@yahoo.com:035533
cccccc@web.de:65333
dddddddd@gmx.de:99948
fffffff@gmx.de:99948
ggggggg@hotmail.com:99948
hhhhhh@gmx ...