Removing whole lines if one CSV Field meets a condition
Posted: Thu May 11, 2006 2:26 am
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.
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.
.