Home > Technology > Importing csv files with , in text field

Importing csv files with , in text field

You would have faced this issue sometimes ot other if you are importing csv files and the text field has , in between.
Since it is CSV (comma separated value) while importing, it will break the text values and move to next column.
Definitely that is not what you want.!
What I do is I go and replace , with \,\

Now when you import, it should be all set

Categories: Technology Tags:
  1. No comments yet.
  1. No trackbacks yet.