CSV files
Posted by Mike on February 12, 2002 7:38 AM
On my computer when I open a CSV file it automatically open the file correctly(each vale is in a separate column and the comma is missing). A coworker opening the same file results in all the values in one column including the comma. There must be a setting that automatically recognizes *.csv files and recognize the comma as a delimiter that is set on my computer but not my coworkers but I don't know where to look.
Posted by Dave on February 12, 2002 7:47 AM
Open his Regional Settings control panel. Examine
the "Number" tab and make sure that the "List
separator" field is set to a comma (,).
Posted by Mark W. on February 12, 2002 7:47 AM
Just a guess...
Open his Regional Settings control panel. Examine
the "Number" tab and make sure that the "List
separator" field is set to a comma (,).
Posted by Mark W. on February 12, 2002 7:49 AM
Dave, looks like my posting clobbered yours...sorry! [nt]
Posted by Mark W. on February 12, 2002 7:49 AM
Dave, looks like my posting clobbered yours...sorry! [nt]
Posted by Dave on February 12, 2002 7:51 AM
Re: no problem. :-) [nt]
Posted by Dave on February 12, 2002 7:51 AM
Re: no problem. :-) [nt]
Posted by Mike on February 12, 2002 8:15 AM
Thanks
Thanks my coworker was located in Belgium where the default list separator is a semi-colon rather than a comma. I never would have consider the regional settings as a source for this problem
Posted by Mike on February 12, 2002 8:15 AM
Thanks
Thanks my coworker was located in Belgium where the default list separator is a semi-colon rather than a comma. I never would have consider the regional settings as a source for this problem
