Happy Business Starts Here

Re: Comma separator issue in API Loader

Highlighted
Zuora Staff

Comma separator issue in API Loader

Problem:  Many of us face the issue in CSV file while loading column values with commas(,). The value that follows the comma automatically goes to the next column.

For Example: Account.csv file
AccountName, AccountNumber
Test, Account, A00000303

Thanks and Regards,
Prem Anandh
1 ACCEPTED SOLUTION

Accepted Solutions
Zuora Staff

Re: Comma separator issue in API Loader

Solution: Use ""(Double Quotes) for any field values having commas(i.e "Test,AccountName"). This will avoid miss placing of column value having commas.
Now the solution to the above example will be
Account.csv file
AccountName, AccountNumber
"Test,Account", A00000303

Thanks and Regards,
Prem Anandh

View solution in original post

1 REPLY 1
Zuora Staff

Re: Comma separator issue in API Loader

Solution: Use ""(Double Quotes) for any field values having commas(i.e "Test,AccountName"). This will avoid miss placing of column value having commas.
Now the solution to the above example will be
Account.csv file
AccountName, AccountNumber
"Test,Account", A00000303

Thanks and Regards,
Prem Anandh

View solution in original post