remove lines according to the first delimited field value

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

sheridany
Posts: 39
Joined: Thu Nov 15, 2007 4:20 am

remove lines according to the first delimited field value

Postby sheridany » Wed Jun 23, 2010 9:16 am

i want to remove lines where the first field delimited contains the number of times the second field occurs. so I want to remove any line where the value is between 1-100. I have tried EP 1 to 3 digits and put a restriction filter above it so it only filters on the first delimited field. No luck there. Any suggestions.

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

Re: remove lines according to the first delimited field value

Postby DataMystic Support » Fri Jun 25, 2010 6:40 am

What delimiter is being used?

You could use an EP to remove matching lines:

Code: Select all

[ lineStart, 1-3 digits, comma ]


if it is CSV - but it depends if the value is quoted or not.
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


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

Who is online

Users browsing this forum: No registered users and 5 guests