Writing pipe delimited data back out as pipe delimited with same exact format as original

Question

Hi,

I am having an issue with writing out data as .txt pipe delimited in the exact same format as the original data. The original data used a CSV reader in order to work with the attributes I needed to modify. But when I try to write it out again as .txt, the format is never exactly the same. I have tried padding the fields, but it does not work.

Example:

Original-

Also, in the output, it continues to add a pipe (|) to the end of each record; the original did not and I need it to not add it in the output.

Any ideas are welcome!

j.botterill · Answer

You might want to explore Dynamic writing, where the CSV schema read, is passed to the writer feature type with Dynamic schema ticked and the user attributes manual removed. This assumes you don’t do any renaming or modification of the schema in the transformation

I would use workflow transformers like FeatureReader and FeatureWriter. The safe articles mostly show how to setup a dynamic workflow using readers with schema as a resource etc.

Writing pipe delimited data back out as pipe delimited with same exact format as original

2 replies

Community Stats

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute