Question Locked

Comma as a data in a input file

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

we have an CSV source file with 3 input which has Comma embedded withing data for instance: xxxx,USA, United State's of America,USD

How is it that we can keep comma part of data. Please elaborate, as I am new to the tool. If your suggestion is to use quotation in source file, and then strip, please inform where should this be done, and just quick example.

I would appreciate.

3 replies

by john.a.wills

More to your point, the solution is to use something other than comma as your CSV delimiter. When you save to the CSV file you should be asked what delimiter you want, although I forget just how it looks.

by older mycroft

When a computer reads a file with a .CSV extension it is expecting a file format that has Comma Separated Values.

I might be (am probably) wrong but I don't think you can over-ride this.

This discussion is closed to new replies.