Skip to main content

@Compif syntax difference in other locales

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?
 

Brian Element Fri, 02/10/2017 - 10:59

In reply to 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

mohamed Thu, 03/09/2017 - 04:24

Hi Brian,
Did you get a chance to find out answer for this from IDEA team?
Thanks,
Shafeer

mohamed Wed, 03/15/2017 - 05:32

Hi Brian,
 
Have you received any update from IDEA on this?
 
Thanks,
Shafeer

Brian Element Wed, 03/15/2017 - 08:59

In reply to by mohamed

Some back and forth but I haven't got an answer  that works yet.  I will keep trying, you might also post your questions to your IDEA supplier if you can contact them.

Brian Element Wed, 03/15/2017 - 20:48

In reply to by mohamed

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

Brian Element Thu, 03/16/2017 - 07:24

In reply to by mohamed

Not a problem, it was an interesting exercise that I had hoped would have a solution.  At this stage I would recommend you go back to your distributor and talk to them about it.

Good luck.

Brian