Forum Discussion

RoyB's avatar
RoyB
New Contributor III
4 years ago

Exporting text file with CSV formatting, but with different numbers of fields

I’m working on a pipeline that needs to create and send a text file to a third party That text file contains rows formatted in the same was as a csv file The file contains a header row, then the ...
csv
mapper
andrew_wait's avatar
andrew_wait
New Contributor
3 years ago

I know I’m late to the party, but I had to do this, found this posting and then solved it this way

FileWriter allows you to append, so

6 columns > CSV (no headers) > FileWriter (overwrite)
33 columns > CSV (no headers) > FileWriter (append)
6 columns > CSV (no headers) > FileWriter (append)

This keeps all the CSV creation so you get the “” wrapping but allows you to build up the file as required.

NOTE: FileWriter is fussy about the target location for allowing append, but if you can jump that hurdle you should be fine