Export text in ""
Tried this again and it sort of works but it is exporting tripple " round the
text!
eg I want 004 to be exported as "004" but it is being exported as """004"""
Very confusing!
--
Regards, Dean
"Melbridge" wrote:
Thought I'd worked this out but it didn't work :-(
Applied a custom number format to the column of \"@\"
This displays " " round the text but doesn't export them to the .csv file.
--
Regards, Dean
"Melbridge" wrote:
I want export (as a csv file) some data to create a TomTom POI file.
I have Latitude, Longitude, Name
I need to export the Name column in " " eg:
53.5,-0.8,"Name of location"
Rather than:
53.5,-0.8,Name of location
Any way to do this?
--
Regards, Dean
|