Hello We have clients sending us xls file. We export them as csv files, using commas or semi-colons. as delimiters and then make an import in mysql. Problem : some of the fields, containing texts, have sometimes already a comma or a semi-colon in them...and when we import, of course MySql thinks the portion between 2 commas for example is a table field...
What can we do ? We can't control what the client have typed, neither tell them "Don't use , or ;" neither ckeck and modify every xls file Thanks for any idea