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

satishnagarajan

24-02-2020

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? 

 

data-extraction.png

 

Thank you!!

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

25-02-2020

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

Answers (0)