| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Separator
I have the following problem:
London based PC A comma delimited file will open correctly if opened with "Open With Microsoft Excel for Windows" (csv extension) Note the list separator within regional settings for UK specifies a comma Madrid PC On a Spanish PC the same file with a semicolon delimiter fails to open correctly even though the regional setting list separator specifies a semicolon. No code is running that might re-set the delimiter Not loading correctly means the delimiter is being ignored. I know that users could solve this by using the import text wizard but I would really like to understand why the list separator in regional settings is being ignored Many Thanks Kieran |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Separator
Kieran,
I can't reproduce this with my English W2K/Office XP. Excel follow the delimiter specified as the List Separator in the Regional Options for opening .csv files. NickHK "Kieran H" wrote in message oups.com... I have the following problem: London based PC A comma delimited file will open correctly if opened with "Open With Microsoft Excel for Windows" (csv extension) Note the list separator within regional settings for UK specifies a comma Madrid PC On a Spanish PC the same file with a semicolon delimiter fails to open correctly even though the regional setting list separator specifies a semicolon. No code is running that might re-set the delimiter Not loading correctly means the delimiter is being ignored. I know that users could solve this by using the import text wizard but I would really like to understand why the list separator in regional settings is being ignored Many Thanks Kieran |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Separator
On Mar 8, 3:36 am, "NickHK" wrote:
Kieran, I can't reproduce this with my English W2K/Office XP. Excel follow the delimiter specified as the List Separator in the Regional Options for opening .csv files. NickHK "KieranH" wrote in message oups.com... I have the following problem: London based PC A comma delimited file will open correctly if opened with "Open With Microsoft Excel for Windows" (csv extension) Note the list separator within regional settings for UK specifies a comma Madrid PC On a Spanish PC the same file with a semicolon delimiter fails to open correctly even though the regional setting list separator specifies a semicolon. No code is running that might re-set the delimiter Not loading correctly means the delimiter is being ignored. I know that users could solve this by using the import text wizard but I would really like to understand why the list separator in regional settings is being ignored Many Thanks Kieran- Hide quoted text - - Show quoted text - Nick, I can't even replicate this problem on a London based pc changed to reflect a Spanish locale! Nevertheless on a PC located in Spain the delimiter is being ignored on "Open With" A debug.print on the Application.International(xlListSeparator) confirms that Excel believes the delimiter to be a semicolon! The file delimiter is definately a semicolon Yet it still fails to open correctly Maybe the installation of Excel is different in some way? Very frustrating!! Thanks for responding Cheers Kieran |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Separator
Kieran,
Under ToolsOptionsInternational, there is a "Use system separators" settings. On my XL XP, this only indicates the Decimal and Thousands separators and that setting has no effect on Excel's handling of .csv files. Maybe their version of Excel is different ? I assume your "definately" does mean "definitely" ? Just check our Chinese XP/Chinese Excel XP and all work as expected. My suspicion would still on the format of the semi-colon text file. Don't suppose it has some extra non printing characters in it? Unicode ? Exactly what do you mean by "Yet it still fails to open correctly" ? NickHK "Kieran H" wrote in message oups.com... On Mar 8, 3:36 am, "NickHK" wrote: Kieran, I can't reproduce this with my English W2K/Office XP. Excel follow the delimiter specified as the List Separator in the Regional Options for opening .csv files. NickHK "KieranH" wrote in message oups.com... I have the following problem: London based PC A comma delimited file will open correctly if opened with "Open With Microsoft Excel for Windows" (csv extension) Note the list separator within regional settings for UK specifies a comma Madrid PC On a Spanish PC the same file with a semicolon delimiter fails to open correctly even though the regional setting list separator specifies a semicolon. No code is running that might re-set the delimiter Not loading correctly means the delimiter is being ignored. I know that users could solve this by using the import text wizard but I would really like to understand why the list separator in regional settings is being ignored Many Thanks Kieran- Hide quoted text - - Show quoted text - Nick, I can't even replicate this problem on a London based pc changed to reflect a Spanish locale! Nevertheless on a PC located in Spain the delimiter is being ignored on "Open With" A debug.print on the Application.International(xlListSeparator) confirms that Excel believes the delimiter to be a semicolon! The file delimiter is definately a semicolon Yet it still fails to open correctly Maybe the installation of Excel is different in some way? Very frustrating!! Thanks for responding Cheers Kieran |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Separator
On Mar 8, 9:46 am, "NickHK" wrote:
Kieran, Under ToolsOptionsInternational, there is a "Use system separators" settings. On my XL XP, this only indicates the Decimal and Thousands separators and that setting has no effect on Excel's handling of .csv files. Maybe their version of Excel is different ? I assume your "definately" does mean "definitely" ? Just check our Chinese XP/Chinese Excel XP and all work as expected. My suspicion would still on the format of the semi-colon text file. Don't suppose it has some extra non printing characters in it? Unicode ? Exactly what do you mean by "Yet it still fails to open correctly" ? NickHK "KieranH" wrote in message oups.com... On Mar 8, 3:36 am, "NickHK" wrote: Kieran, I can't reproduce this with my English W2K/Office XP. Excel follow the delimiter specified as the List Separator in the Regional Options for opening .csv files. NickHK "KieranH" wrote in message roups.com... I have the following problem: London based PC A comma delimited file will open correctly if opened with "Open With Microsoft Excel for Windows" (csv extension) Note the list separator within regional settings for UK specifies a comma Madrid PC On a Spanish PC the same file with a semicolon delimiter fails to open correctly even though the regional setting list separator specifies a semicolon. No code is running that might re-set the delimiter Not loading correctly means the delimiter is being ignored. I know that users could solve this by using the import text wizard but I would really like to understand why the list separator in regional settings is being ignored Many Thanks Kieran- Hide quoted text - - Show quoted text - Nick, I can't even replicate this problem on a London based pc changed to reflect a Spanish locale! Nevertheless on a PC located in Spain the delimiter is being ignored on "Open With" A debug.print on the Application.International(xlListSeparator) confirms that Excel believes the delimiter to be a semicolon! The file delimiter is definately a semicolon Yet it still fails to open correctly Maybe the installation of Excel is different in some way? Very frustrating!! Thanks for responding Cheers Kieran- Hide quoted text - - Show quoted text - Nick, I am using Excel 2000 and do not have an international tab under options. In response to your point re non printable characters, I created a very short csv file (ansi) in note pad. The semicolon delimited file when opened on a London based PC with the list separator also set to semicolon breaks the fields into the correct columns If I do the same on a Spanish pc the list separator is ignored and the data is dumped into the left most cell despite the fact that Application.International(xlListSeparator) reports a semicolon delimiter The Spanish pc has the same build but has a Spanish language pack loaded Regards Kieran |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List Separator
Kieran,
I'm out of suggestions then. Seems strange that the Spanish version should behave differently to all/most others though. NickHK "Kieran H" wrote in message oups.com... On Mar 8, 9:46 am, "NickHK" wrote: Kieran, Under ToolsOptionsInternational, there is a "Use system separators" settings. On my XL XP, this only indicates the Decimal and Thousands separators and that setting has no effect on Excel's handling of .csv files. Maybe their version of Excel is different ? I assume your "definately" does mean "definitely" ? Just check our Chinese XP/Chinese Excel XP and all work as expected. My suspicion would still on the format of the semi-colon text file. Don't suppose it has some extra non printing characters in it? Unicode ? Exactly what do you mean by "Yet it still fails to open correctly" ? NickHK "KieranH" wrote in message oups.com... On Mar 8, 3:36 am, "NickHK" wrote: Kieran, I can't reproduce this with my English W2K/Office XP. Excel follow the delimiter specified as the List Separator in the Regional Options for opening .csv files. NickHK "KieranH" wrote in message roups.com... I have the following problem: London based PC A comma delimited file will open correctly if opened with "Open With Microsoft Excel for Windows" (csv extension) Note the list separator within regional settings for UK specifies a comma Madrid PC On a Spanish PC the same file with a semicolon delimiter fails to open correctly even though the regional setting list separator specifies a semicolon. No code is running that might re-set the delimiter Not loading correctly means the delimiter is being ignored. I know that users could solve this by using the import text wizard but I would really like to understand why the list separator in regional settings is being ignored Many Thanks Kieran- Hide quoted text - - Show quoted text - Nick, I can't even replicate this problem on a London based pc changed to reflect a Spanish locale! Nevertheless on a PC located in Spain the delimiter is being ignored on "Open With" A debug.print on the Application.International(xlListSeparator) confirms that Excel believes the delimiter to be a semicolon! The file delimiter is definately a semicolon Yet it still fails to open correctly Maybe the installation of Excel is different in some way? Very frustrating!! Thanks for responding Cheers Kieran- Hide quoted text - - Show quoted text - Nick, I am using Excel 2000 and do not have an international tab under options. In response to your point re non printable characters, I created a very short csv file (ansi) in note pad. The semicolon delimited file when opened on a London based PC with the list separator also set to semicolon breaks the fields into the correct columns If I do the same on a Spanish pc the list separator is ignored and the data is dumped into the left most cell despite the fact that Application.International(xlListSeparator) reports a semicolon delimiter The Spanish pc has the same build but has a Spanish language pack loaded Regards Kieran |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list separator | Excel Discussion (Misc queries) | |||
| How to use comma as list separator instead semicolon? | Setting up and Configuration of Excel | |||
| list separator | Excel Programming | |||
| TAB as list separator via regional setting | Excel Discussion (Misc queries) | |||
| list separator settings | Excel Discussion (Misc queries) | |||
Hybrid Mode
