How to Delete file after @

talput · Post by **talput** » Thu Jun 28, 2012 6:27 am

Hi....i'm new member here, before post this question i seach first and cant find the answer.

i have file like this (colom 1=email and column 2= username )
member1@yahoo.com:uieroer
user12@hotmail.com:iekorler
user13@gmail.com:kolimper

I need to delete all data after @ and keep the :

The result will be
member1:uieroer
user12:iekorler
user13:kolimper

Thanks for help...

ak47wong · Post by **ak47wong** » Thu Jun 28, 2012 7:55 am

Click Search > Replace and enter the following:

Find what: @[^:]*
Replace with: [nothing]

Select the Regular expression check box and click Replace All.