Insert a row content in a CSV or EXCEL which is extracted using a DATA extraction activity in a workflow

[satishnagarajan]

Hi,

I'm trying to insert a new row with content as header and description inside a CSV or Excel sheet using the data extraction.

I'm able to insert data as columns, Is it possible to insert a row using a script? 

Thank you!!

[Jonathon_wodnicki · Accepted solution]

Hi,

Yes, this is trivial with scripting, e.g. execCommand("sed -i '1s/^/<added text>/'").

The data extraction activity supports column headers though, so this should be unnecessary.

Thanks,

-Jon

[parmeshwarr3905]

Hi @satishnagarajan  I've a requirement to insert data as column(header name) since while data extraction even if we select the option to populate first column as header, for blank file the headers are not populating in current campaign version , could you share how you have achieved this? Through script or any other way?