Community

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...

Click Search > Replace and enter the following:

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

Select the Regular expression check box and click Replace All.