0

We would like to export a Marketing Cloud Discovery report. Marketing Cloud only gives you four options for download or SFTP: .csv, pdf., .xlsx, .xsl . Is there a workaround for transforming a columned report into a pipe-delimited .txt file?

Our aim is trying to export the report, then import that report into a data extension. The only issue is that when we import the .csv, we have to select ',' as a delimiter. This causes an exception, as we have some data that has ',' in the values themselves. This causes an InvalidFieldCount error upon import.

1 Answer 1

2

When you export a Discover report as a csv file, Discover uses double-quote as the text qualifier. In order to successfully import a file like this to a Data Extension, ensure you check the "Respect double quotes as a text delimiter" box when defining the Import Definition.

enter image description here

In this way, you'll see data that incorporates commas successfully import into your DE:

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .