Page 1 of 1

remove lines according to the first delimited field value

Posted: Wed Jun 23, 2010 9:16 am
by sheridany
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.

Re: remove lines according to the first delimited field value

Posted: Fri Jun 25, 2010 6:40 am
by DataMystic Support
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.