Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.vc.mfc
|
|||
|
|||
CSV (Comma Separated Values) delimiter ?
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 |
#2
Posted to microsoft.public.excel.programming,microsoft.public.vc.mfc
|
|||
|
|||
CSV (Comma Separated Values) delimiter ?
Can anyone tell me where I can find what delimiter is being used on that
PC? Application.International(xlColumnSeparator) -- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming,microsoft.public.vc.mfc
|
|||
|
|||
CSV (Comma Separated Values) delimiter ?
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. -- Regards, Tom Ogilvy "Lisa Pearlson" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming,microsoft.public.vc.mfc
|
|||
|
|||
CSV (Comma Separated Values) delimiter ?
Disregard - thought you wanted to change it.
-- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... 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. -- Regards, Tom Ogilvy "Lisa Pearlson" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming,microsoft.public.vc.mfc
|
|||
|
|||
CSV (Comma Separated Values) delimiter ?
The settings is based on indivudual user. Try
Key: HKEY_CURRENT_USER\Control Panel\International Name: sList -- Cheers Check Abdoul [VC++ MVP] ----------------------------------- "Lisa Pearlson" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming,microsoft.public.vc.mfc
|
|||
|
|||
CSV (Comma Separated Values) delimiter ?
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. "Jim Rech" wrote in message ... Can anyone tell me where I can find what delimiter is being used on that PC? Application.International(xlColumnSeparator) -- Jim Rech Excel MVP |
#7
Posted to microsoft.public.excel.programming,microsoft.public.vc.mfc
|
|||
|
|||
CSV (Comma Separated Values) delimiter ?
Thanks!
"CheckAbdoul" <checkabdoul at mvps dot org wrote in message ... The settings is based on indivudual user. Try Key: HKEY_CURRENT_USER\Control Panel\International Name: sList -- Cheers Check Abdoul [VC++ MVP] ----------------------------------- "Lisa Pearlson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I create a comma separated values file | Excel Discussion (Misc queries) | |||
How do I convert a column of numbers into comma separated values . | Excel Worksheet Functions | |||
How do I convert an excel file into a comma separated values file | Excel Discussion (Misc queries) | |||
Fixing Comma Separated Values (.csv) | Excel Discussion (Misc queries) | |||
how could I import a text file with comma separated values into ex | Excel Worksheet Functions |