Off Topic possibly

[Jack Russell]

Re: Off Topic possibly

Cor Ligthert[MVP] wrote:

Jack,
>
As far as I know is the standard string seperation character for all non
English European languages the ";".
>
For the rest are the cultures setting doing all the work.
>
I don't know how the decimal seperator is showed up in things as
intelligence in your IDE. In my English IDE the comma separator is
showed as a dot while for output that is translated to a comma, while my
culture settings are Dutch.
>
Cor

Good to hear from you Col. take a look in any American Spanish language
in Regional settings under XP or Vista and you will see the list
separator is a comma.(,). I am convinced this a Microsoft "mistake" but ....

And thanks for saying it was not Off Topic!

Jack Russell

[=?Utf-8?B?TS4gUG9zc2V0aA==?=]

Re: Off Topic possibly

Well just as i thought exactly the same behavior as with my dot vs comma
problem

if you set

Imports System.Globaliz ation

and then compare these 2 values

NumberFormatInf o.CurrentInfo.N umberDecimalSep erator

CultureInfo.Cur rentCulture.Tex tinfo.ListSeper ator

you could check if they are the same and so acordingly take your own list
seperator
this way you mimick the behavior of Microsoft products as Excel

i guess this is much safer as depending on your users to have and hold the
correct cultureinfo

regards

Michel


"Jack Russell" wrote:

Michel,
>
I did some test with excel and it seeks to force the list separator to
semi colon if the decimal separator is comma.
>
My client asked one of his employees who is Venezuelan how it worked
with the decimal and list separators being both comma and his reply was
"if the software does not work we set our PC to US English!"
>
I like your translating the input character idea but am still confused
if the American Spanish expect both decimal and list to be comma how do
I know which he meant to hit!
>
>
>
Jack
>
>
>
Michel Posseth [MCP] wrote:

Well wait untill you must write programs for the Netherlands , where the
decimal seperator is a ',' but every person is using a US keyboard if you
then have to write data entry applications on numeric fields you get the
funny situation that a "." is entered by the user when he actually expects a
"," although he hitted the "." key on the numeric pad , and this is in the
Netherlands wrong , when we did some investigation we noticed that all MS
products ( calculator , office etc etc ) simply check the settings and if
needed change the "." to a "," so on the fly we simply change the numeric
"." to a "," when pressed :-)

You could do the same thing i guess when your program exports data just
change the lisseperator to another value if it is a "," however this will
not solve the issue when a user wants to import a file with "," seperated
columns and numeric fractional digits

HTH

Michel


"Jack Russell" <jackr@norubbis h.tpg.com.ausch reef in bericht
news:OF%23nBoxJ IHA.3356@TK2MSF TNGP02.phx.gbl. ..

>Michel,
>
>Trouble is the client does not want to change the software just for this
>instance. It seems strange to me that "Spanish America" has these
>contradictor y settings.
>
>So, the client wants me to warn if the settings conflict and let the end
>user sort it out!
>
>However thanks for your suggestions, if I ever do another project like
>this I will take them on board.
>
>Jack
>
>Michel Posseth [MCP] wrote:
>
>>when i went international with programming , a long long time ago when
>>..Net was not yet invented :-)
>>i choose Tab (blabla blabla) delimited or pipe (blabla|blabla )
>>delimited formats
>>
>>for these situations 1,2,3 was it 1.23 or 12.3 or 1 and 2.3 or 1.2
>>and 3 etc etc etc is simply no solution if you can`t enforce / asume
>>region / culture settings
>>
>>so you should write deliver your data in a global way , ever thought
>>about a lightweight database ? ( sql server everywhere for instance )
>>
>>regards
>>
>>Michel
>>
>>
>>"Jack Russell" <jackr@norubbis h.tpg.com.ausch reef in bericht
>>news:eMWI3qvJ IHA.5860@TK2MSF TNGP04.phx.gbl. ..
>>
>>
>>>I use comma delimited strings in data files.
>>>
>>>If I set my computer region/ culture to Spanish / Argentina the decimal
>>>character and the list separator are both set to "'" (comma.
>>>
>>>This makes decoding the strings almost impossible in certain cases.
>>>
>>>Anyone know if this is really rue for that locale or is it an XP bug.
>>>Where would be the right forum to get an answer to this.
>>>
>>>Thanks
>>>
>>>Jack Russell
>>
>>

>

[Jack Russell]

Re: Off Topic possibly

While my client makes his mind up I have put a warning in the program
"decimal and separator characters identical, please adjust regional
settings ......."

Jack



M. Posseth wrote:

Well just as i thought exactly the same behavior as with my dot vs comma
problem
>
if you set
>
Imports System.Globaliz ation
>
and then compare these 2 values
>
NumberFormatInf o.CurrentInfo.N umberDecimalSep erator
>
CultureInfo.Cur rentCulture.Tex tinfo.ListSeper ator
>
you could check if they are the same and so acordingly take your own list
seperator
this way you mimick the behavior of Microsoft products as Excel
>
i guess this is much safer as depending on your users to have and hold the
correct cultureinfo
>
regards
>
Michel
>
>
"Jack Russell" wrote:
>
>

>>Michel,
>>
>>I did some test with excel and it seeks to force the list separator to
>>semi colon if the decimal separator is comma.
>>
>>My client asked one of his employees who is Venezuelan how it worked
>>with the decimal and list separators being both comma and his reply was
>>"if the software does not work we set our PC to US English!"
>>
>>I like your translating the input character idea but am still confused
>>if the American Spanish expect both decimal and list to be comma how do
>>I know which he meant to hit!
>>
>>
>>
>>Jack
>>
>>
>>
>>Michel Posseth [MCP] wrote:
>>

>>>Well wait untill you must write programs for the Netherlands , where the
>>>decimal seperator is a ',' but every person is using a US keyboard if you
>>>then have to write data entry applications on numeric fields you get the
>>>funny situation that a "." is entered by the user when he actually expects a
>>>"," although he hitted the "." key on the numeric pad , and this is in the
>>>Netherland s wrong , when we did some investigation we noticed that all MS
>>>products ( calculator , office etc etc ) simply check the settings and if
>>>needed change the "." to a "," so on the fly we simply change the numeric
>>>"." to a "," when pressed :-)
>>>
>>>You could do the same thing i guess when your program exports data just
>>>change the lisseperator to another value if it is a "," however this will
>>>not solve the issue when a user wants to import a file with "," seperated
>>>columns and numeric fractional digits
>>>
>>>HTH
>>>
>>>Michel
>>>
>>>
>>>"Jack Russell" <jackr@norubbis h.tpg.com.ausch reef in bericht
>>>news:OF%23nB oxJIHA.3356@TK2 MSFTNGP02.phx.g bl...
>>>
>>>
>>>>Michel,
>>>>
>>>>Trouble is the client does not want to change the software just for this
>>>>instance. It seems strange to me that "Spanish America" has these
>>>>contradicto ry settings.
>>>>
>>>>So, the client wants me to warn if the settings conflict and let the end
>>>>user sort it out!
>>>>
>>>>However thanks for your suggestions, if I ever do another project like
>>>>this I will take them on board.
>>>>
>>>>Jack
>>>>
>>>>Michel Posseth [MCP] wrote:
>>>>
>>>>
>>>>>when i went international with programming , a long long time ago when
>>>>>..Net was not yet invented :-)
>>>>>i choose Tab (blabla blabla) delimited or pipe (blabla|blabla )
>>>>>delimite d formats
>>>>>
>>>>>for these situations 1,2,3 was it 1.23 or 12.3 or 1 and 2.3 or 1.2
>>>>>and 3 etc etc etc is simply no solution if you can`t enforce / asume
>>>>>region / culture settings
>>>>>
>>>>>so you should write deliver your data in a global way , ever thought
>>>>>about a lightweight database ? ( sql server everywhere for instance )
>>>>>
>>>>>regards
>>>>>
>>>>>Michel
>>>>>
>>>>>
>>>>>"Jack Russell" <jackr@norubbis h.tpg.com.ausch reef in bericht
>>>>>news:eMWI3 qvJIHA.5860@TK2 MSFTNGP04.phx.g bl...
>>>>>
>>>>>
>>>>>
>>>>>>I use comma delimited strings in data files.
>>>>>>
>>>>>>If I set my computer region/ culture to Spanish / Argentina the decimal
>>>>>>charact er and the list separator are both set to "'" (comma.
>>>>>>
>>>>>>This makes decoding the strings almost impossible in certain cases.
>>>>>>
>>>>>>Anyone know if this is really rue for that locale or is it an XP bug.
>>>>>>Where would be the right forum to get an answer to this.
>>>>>>
>>>>>>Thanks
>>>>>>
>>>>>>Jack Russell
>>>>>
>>>>>