@Compif syntax difference in other locales
Forums
Hi,
I am using @compif function in equation for appending field through idea script. This works fine in English/United states locale. When I changed locale to French, the equation is not working.
Each condition in @compif is separated by comma (,). But in French locale, it is showing that semi colon (;) has to be used for each condition.
So my code is not working in French/German locales.
Syntax for English: @CompIf(<num> Condition1 , <any> Result1 , <num>Condition2 , <any> Result2,...)
Syntax for French: @CompIf(<num> Condition1 ; <any> Result1 ; <num>Condition2 ; <any> Result2;...)
See screen shots attached for equation editor in English and French locales. Ideally method syntact should be same irrespective of locale. Correct?
Is there any way to make this function working in all locales?
Hi Shafeer,
Hi Shafeer,
I was at the IDEA offices today so I got to talk to some of the experts and it looks like this is something that might not be possible to currently do in IDEA. The problem as you are aware is that in Windows the list separator and the comma are the same in this language and there doesn't seem to be away around this right now other than changing your regional settings to another language. The problem is IDEA gets the list separator and the decimal from the regional settings within IDEA, as they are both the same the equation editor doesn't know what to do with them. Sorry, I know this wasn't what you were hoping to hear.
Good luck on your project.
Brian
Hi Shafer,
In reply to Hi Brian, by mohamed
Hi Shafer,
That is an interesting question and I don't have an answer for you. I will try and find out from my friends at IDEA how it is done.
Brian