save file as CSV

[austenr]

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]

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]

Good idea, hadn't thought of that