DSXchange

exactly what I was looking for, thanks ray!

I need to do some name cleansing, and I'm using the USNAME Standardize stage, but there's some additional prep and cleanup I need to do on the names using Transformer stages. However, I have about 20 very different input files that all need to run through this identical name cleanse process, which c...

Yup, that's what I ended up doing. Thanks everyone for your help.

Why not have multiple outputs from the CFF stage to receive the different record types? ... That would be great, but I can't find a way to describe my records in CFF. Only my header and trailer have a record ID, the data records don't have any identifying ID. But the CFF requires a record ID, and t...

I don't want to strip the header and trailer, that's my point. I want to keep them because they have data that I need to compare to the rest of the data records. Also, the header and trailer records aren't the same length as the data records, so I can't use a fixed-length file stage. I can't get it ...

I'm having an issue defining a CFF that I don't see addressed in any other threads I've seen. My input file has a header and a trailer, defined by "HDDR" and "TRLR". The data records between the header/trailer do not have a record identifier. So on the "Records ID" tab,...