This one may not be possible but I'm gonna ask anyway just in case some of you have done it before. I have a function that takes a string argument and converts it to an English format. The string is always numeric, for example "1.5"; but not always using the English format, for example "1,5". Converting the string is really easy as long as the format always comes in the same way. But that's not the case here; the first time it gets called the format may be in English while the next time it may be in Dutch, or some other format.
What I need to do is determine if the string is in English format or some other format before I perform the conversion. So the pseudocode would look like this:
Determine if the numeric string passed in is in English format.
If string is in English format then do not convert.
If string is NOT in English format then convert and return new string.
I've looked at looping through the string and I've tried removing all thousands separators, but nothing works for all possible situations. The one that causes the most trouble is when the regional setting for the machine is NOT English but the string passed in is in an English format.