how can i delet line deponding the end line text ?

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

marouf3d
Posts: 6
Joined: Fri May 22, 2009 12:57 am

how can i delet line deponding the end line text ?

Postby marouf3d » Fri May 22, 2009 1:17 am

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

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

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

Postby DataMystic Support » Tue May 26, 2009 11:27 am

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 ]
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

marouf3d
Posts: 6
Joined: Fri May 22, 2009 12:57 am

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

Postby marouf3d » Wed May 27, 2009 10:15 am

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

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

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

Postby DataMystic Support » Wed May 27, 2009 10:41 am

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

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

marouf3d
Posts: 6
Joined: Fri May 22, 2009 12:57 am

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

Postby marouf3d » Wed May 27, 2009 10:56 am

Yes Man


thank you so much for your help


it is Ok now :)

marouf3d
Posts: 6
Joined: Fri May 22, 2009 12:57 am

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

Postby marouf3d » Sat Jan 02, 2010 4:59 pm

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
Posts: 6
Joined: Fri May 22, 2009 12:57 am

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

Postby marouf3d » Sat Jan 02, 2010 8:56 pm

i find a good solution

Code: Select all

[5 or more not '.', lineend]




thaaaaaaaaanks


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 1 guest