Export data as TXT file using Export Sets

[siva81]

Hi All,

Our requirement is export the table data as TXT file into a Mid Server location.We are able to export the data as a CSV file using Export Sets. I would like to know is there way to export the data as TXT file directly or convert the file from CSV to TXT after exporting using post-export script? Also, I would like to know can we add one more option to the drop-down field "Format" in the export sets form? Thank you so much for your time and help in advance.

[Ankur Bawiskar]

Hi Siva,

Export sets have their own limitation in terms of csv file.

Every field is separated by comma, every row delimited with new line, field values wrapped in double quotes.

So it would be difficult to customize the csv export set.

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

Hi Siva,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur

[Ankur Bawiskar]

Hi Siva,

Can you also mark answer as correct.

Regards

Ankur

[kunal16]

Hi Ankur,

I have one similar requirement - I am able to create the Export Set but not sure how can I customize the MID Server configuration to convert the CSV file to txt, can you please elaborate more on that?

[Ankur Bawiskar]

Hi Kunal,

you would require to have mid server script include which is combination of java+javascript and then convert it to txt file

Regards

Ankur Bawiskar