remove lines according to the first delimited field value

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

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