Problem in importing the CSV file containing multiple commas in a sigle field
- by kakaajee
Hi Experts,
I am having an issue with importing a large(60MB) CSV file in MYSQL DB.
The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc.
I tried to use BigDump for it but, the problem did not solved because of a single field containing multiple comma separated values.
Any idea, suggestion or solution from experts how to handle it?
Please reply, because I am sick of it.
Thanks