How to define csv separator

  • Thread starter Thread starter Dr. Wolfgang Hintze
  • Start date Start date
D

Dr. Wolfgang Hintze

How can I define the separating character for a csv file (currently it
is ";")?

Any hints are greatly appreciated.

Wolfgang
 
Hi Wolfgang

It's in Windows' Control Panel, Regional Settings, Numbers, the List Separator entry (at
least on my Win98). You're, like me, live in a country that use comma as decimal
separator, so you must reset a lot of things there to produce a "true american csv file".

Or, you can use Chip's code at http://www.cpearson.com/excel/imptext.htm for more control
of the input/output.
 
Back
Top