I have an excel sheets which contain information which will be exported via CSV in Excel and later be imported via CSV into a mysql database.
The problem is that some columns in the excel can contain quite a few common delimiters such as commas, apostrophes for text fields, along with single and double quotes being used to hold longitude/latitude fields (in degrees minutes and seconds.
I notice that no fields contain | and perhaps it could be used to enclose fields, and still delimit with commas.
How would one go about producing a CSV with | used to enclose fields?
The problem is that some columns in the excel can contain quite a few common delimiters such as commas, apostrophes for text fields, along with single and double quotes being used to hold longitude/latitude fields (in degrees minutes and seconds.
I notice that no fields contain | and perhaps it could be used to enclose fields, and still delimit with commas.
How would one go about producing a CSV with | used to enclose fields?