Happy Business Starts Here

Partner

Rules for adding quote on file csv

this support is to know the extraction rule applied to the string format for the creation of Batch_query file.

In particular, we need to know when the char “ is applied for a string, below an example:

Product Name Zuora = SM - Sconto Variabile "ROMA" -> in the Output file the string is written as “SM - Sconto Variabile “"ROMA"””.

So, could you tell me when the “ char is added when a string is writted in a CSV?

 

Tags (2)
1 REPLY 1
Zuora Alumni

Re: Rules for adding quote on file csv

Hi @attaciro

 

csv columns are escaped when they contain commas or quotes

 

quotes in the field are also double qouted



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √