Happy Business Starts Here

Highlighted
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 √