Comma separator issue in API Loader

[pramamoorthy]

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

[pramamoorthy · Accepted solution]

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