Page 1 of 1

how can i delet line deponding the end line text ?

Posted: Fri May 22, 2009 1:17 am
by 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[/size]

Re: how can i delet line deponding the end line text ?

Posted: Tue May 26, 2009 11:27 am
by 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 ]

Re: how can i delet line deponding the end line text ?

Posted: Wed May 27, 2009 10:15 am
by 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 ..

Re: how can i delet line deponding the end line text ?

Posted: Wed May 27, 2009 10:41 am
by 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.

Re: how can i delet line deponding the end line text ?

Posted: Wed May 27, 2009 10:56 am
by marouf3d
Yes Man


thank you so much for your help


it is Ok now :)

Re: how can i delet line deponding the end line text ?

Posted: Sat Jan 02, 2010 4:59 pm
by 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

Re: how can i delet line deponding the end line text ?

Posted: Sat Jan 02, 2010 8:56 pm
by marouf3d
i find a good solution

Code: Select all

[5 or more not '.', lineend]


thaaaaaaaaanks