Extra quotes in CSV file (""") Help !

F

Fred Collins

If I write a excel file that has a string as follows:

( 1,"ABC",2 ) the csv file contains ( 1,"""ABC""",2 ). How do I trun off
the 2 extra ( " ). ???

[email protected]
 
E

Earl Kiosterud

Fred,

Those extra quotes are intentional and necessary. For a description read "Delimited Text
file" at http://www.smokeylake.com/excel/textfiles.htm
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Top