austenr
06-07-2007, 11:49 AM
Hi all,
I need to save the attached as a CSV file with the fields enclosed in " ", fields terminated by ";" in ascii format. I need to import this into a mySQL table. The part that throws me is that the first field has ; in the field description which needs to stay there (I think it looks bad).
So if you import it as fields terminated by ; then i will end up with bogus data. Any suggestions appreciated.
I need to save the attached as a CSV file with the fields enclosed in " ", fields terminated by ";" in ascii format. I need to import this into a mySQL table. The part that throws me is that the first field has ; in the field description which needs to stay there (I think it looks bad).
So if you import it as fields terminated by ; then i will end up with bogus data. Any suggestions appreciated.