DataMystic

Thanks Simon. That worked! I did try it before with the secondary output, but I probably didn't have the right filters setup in the T-filter. You cannot check if the filter is working within the T-filter it seems. But if you bring the filters just above the filter to test to make sure it's extractin...

I've searched the forum and the documentation but have not been able to find a solution to my problem. In my original input text file, there is a date field that is not providing the 2 digit century numbers. 99 instead of 1999, or 05 instead of 2005. Is it possible to create a filter that will let m...

I have data that i managed to filter as follows: A 12345,John Smith,Los Angeles,CA B 12345,Albertsons,Cashier C 12345,Blue Cross,HMO A 54321,Sam Knight,Cerritos,CA B 54321,Acme Widgets,Security Guard C 54321,Aetna,PPO A 98765,Alexis Jackson,El Segundo,CA B 98765,Farmer Boys,Cashier C 98765,Kaiser,PP...