how can i delet line deponding the end line text ?

[marouf3d]

Hi Boys ..

How are you ...

i have a milling list, I need to remove some emails depending the ends .

some adresses are like :

username@domainname.codssjsa
username@domainname.co.kjhd
username@domainname.1d.kj02

in this case i need to remove this lines.

but i don't know if the numbers are allowed or not i the end of the domain name.

i am using REMOVE MATCHING LINES with textEnd

i need to remove the line if the end is more then 3 letters ..

for example : if the end is ".com" it will not remove the line because the end is 3 letters or less.

but if the end is ".comd", it will not remove the line (more then 3 letters)

i try

Code: Select all

['.', [4 to 20 letter]]

but ut is not working


i try also ..

Code: Select all

mustEndWith("." + 4 to 20 letter )]

BUT NOT WORKING ALSO ..


i am using the easy pattern code way

if you can help me on other way no problem ..

many thanks for your help

[DataMystic Support]

Use Filters\Remove\Remove lines\Remove non-matching lines

with an EasyPattern match (as you have done), with a pattern of

Code: Select all

['.', 2 .. 3 letters ]

[marouf3d]

Hi,

many thank for your answer.

logically, your answer is OK

but it is deleting the line if it is not matching any part, not the end only.

i am using it also with

Code: Select all

mustEndWith

but it deleting everything.

many thanks for your help ..

[DataMystic Support]

You said

remove some emails depending the ends

Anyway, use a search replace EasyPattern:

Code: Select all

[ '.', 4 or more letters or digits, lineend ]

Replace with nothing. Remember to turn prompting on so you can see what it finds.

[marouf3d]

Yes Man


thank you so much for your help


it is Ok now

[marouf3d]

Hi

i have a problem, it deleting any email with more then one point in the domain name like :

user@domain.net.ae

I'm trying

Code: Select all

[ '.', 4 or more <.> , lineend ]

with easy pattern mode but it is not working too.

the problem in the previous solution was the code is start calculation from the first dote, it should calculate from the last dote in the email address

it means
in the end of the line we should have dot with 3 letters or digits except dot

any suitable way to translate that to code ?

thank you in advance

[marouf3d]

i find a good solution

Code: Select all

[5 or more not '.', lineend]

thaaaaaaaaanks