PDA

View Full Version : save file as CSV



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.

Oorang
06-07-2007, 12:43 PM
If you cannot change your import spec, then personally I would replace all occurances ";" with something unlikely such as ":::" (or something else) before I saved to csv. Then I would import my data and just run an update query to change ":::" back to ";".

austenr
06-07-2007, 12:44 PM
Good idea, hadn't thought of that