DataMystic

I need to alter some values in a CSV table when certain conditions are met. I tried using the character math filter and that just put out strange symbols in front of the number I was trying to change. I was thinking about using JScript to do it but I don't know how to reference the value being read....

Nevermind, I figured out a way to do it .

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