- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
Prem Anandh
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
Prem Anandh
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
Prem Anandh