Creating a .csv with multiple formats

brianscott

Hello gurus - 

For some reason, our vendor wants a csv that has multiple record definitions within the same .csv

type, action, account, name

A, add, 012345, 'brian'

A, update, 23456, 'scott'

type, action, address, major_malfunction

P, add, 942 evergreen terrace, 'insufficient funds'

P, delete, 300 main street, 'Main street closed due to lack of interest'

Gathering the data is easy.  Getting it out into a single .csv is a little more vexing.  Anyone have any ideas?  

Thanks. 

brian

BenMoss

What issue are you facing exactly when trying to write this to a CSV?

I would consider building all of this and writing it as an 'undelimited' csv file (\0) but you will have already built the '.csv' structure within the workflow, by adding delimiters and qoutation marks where applicable.

If that makes any sense.

Ben