Page 1 of 1

Removing whole lines if one CSV Field meets a condition

Posted: Thu May 11, 2006 2:26 am
by jmbarnet
I'm using textpipe to change some CSV files. If a specific field is empty, I need to delete the entire line. I tried using restrict filters to look at the specific fields only and when I do remove all it only deletes the lines inside of that field.

Here is some sample input:

ABC123,123456,12/6/2005,blahblah,3, ,,ABC

I want the whole line deleted if either CSVfields 5 or 6 are blank.

Here is the easypattern i tried with a remove non-matching lines filter:

[longest oneOrMore letters, longest oneOrMore digits][comma][longest oneOrMore digits][comma][(digit,digit,slash,digit,digit,slash,digit,digit,digit,digit) or (digit,digit,slash,digit,slash,digit,digit,digit,digit)][comma][CSVField][comma][(longest oneOrMore digits) or (longest oneOrMore digits period longest oneOrMore digits)][comma][longest oneOrMore digits][comma][comma]['ABC']

The funny thing is that I had this working yesterday and I come in today and now it doesn't. Any help would be greatly appreciated.

Posted: Thu May 11, 2006 10:01 pm
by jmbarnet
Nevermind, I figured out a way to do it :D .