Hello. I'm new to UltraEdit app. if this questions has been asked before, my apologies

Example:
I have .csv files filled with dump emails and need to know how to delete duplicates then split multiple entries into their own lines, and remove emails domain with @gmail.com.

here is the current view:

[email protected]
[email protected]; [email protected]; [email protected], [email protected], [email protected]


here is the expected view:

[email protected]
[email protected]
[email protected]
[email protected]

Thank you in advance.

Hi,

You can use Perl regular expressions to achieve your goal.

1st step - split multivalues lines
F: [;,] *
R: \r\n

2nd step - delete lines with gmail email
F: ^.*@gmail\.com\r\n
R: <leave it empty>

3rd step - remove duplicates
3a) using Perl regex
F: ^(.+)\r\n(?=(?s:.*?^\1$))
R: <leave it empty>
or
3b) using sort lines (contemporary menu): Edit, Sort, Advanced sort/Options...  and check the option Remove Duplicates (RD)

BR, Fleggy

Thank you!