CSV (Comma Separated Values) delimiter ?

[Lisa Pearlson]

Hi,

My app exports data in CSV format, using comma separated values.
A .csv file is associated with Excel by default and clicking on it opens it
up in Excel.
However, the delimiter depends on regional settings.
Using a comma when regional settings are for the Netherlands, fails because
it expects a semicolon then.
For USA it is a comma.

This information should be stored somewhere in the windows registry.
Can anyone tell me where I can find what delimiter is being used on that PC?

Lisa

 

[Jim Rech]

Can anyone tell me where I can find what delimiter is being used on that
PC?


Application.International(xlColumnSeparator)

 

[Tom Ogilvy]

It is a Windows setting.
in the Windows control panel (under Start=>Settings=>Control Panel), look in
the Regional Settings icon. In the Numbers tab, look at the List Separator
character.

 

[Tom Ogilvy]

Disregard - thought you wanted to change it.

 

[CheckAbdoul]

The settings is based on indivudual user. Try

Key: HKEY_CURRENT_USER\Control Panel\International
Name: sList

 

[Lisa Pearlson]

Not using VB but VC++. I really want to fetch this from the windows registry
myself. I'm pretty sure it's there somewhere.
Not sure where the regional settings are stored in the windows registry.

 

[Lisa Pearlson]

Thanks!

The settings is based on indivudual user. Try

Key: HKEY_CURRENT_USER\Control Panel\International
Name: sList
--
Cheers
Check Abdoul [VC++ MVP]
-----------------------------------

Hi,

My app exports data in CSV format, using comma separated values.
A .csv file is associated with Excel by default and clicking on it opens it
up in Excel.
However, the delimiter depends on regional settings.
Using a comma when regional settings are for the Netherlands, fails because
it expects a semicolon then.
For USA it is a comma.

This information should be stored somewhere in the windows registry.
Can anyone tell me where I can find what delimiter is being used on that PC?

Lisa