Case sensitivity when using IF-THEN-ELSEIF within Formula Tool

[Katie_K]

Hi folks, I am wondering if the formula tool will evaluate an expression / calculation while considering a text's case.

For example, would these 3 lines effectively be the same thing?  Or would it evaluate the first line and decide if the case of the text matches in all caps before moving to the next line... and then in THAT line decide if it matches with a mix of upper and lower, and then finally move to the third line looking for all lower case - ?  Which might imply that the SEQUENCE of your IF-THENs would matter (??). 

If there is another thread on this I'd be happy to review... thanks, Katie

Creating a new column called Status:

IF OLD = 'ACTIVE' AND NEW = 'ACTIVE X' THEN 0

ELSEIF OLD = 'Active' AND NEW = 'Active x' THEN 0

ELSEIF OLD = 'active' AND NEW = 'active x' THEN 0

ELSE 0

END

[atcodedog05]

Hi @Katie_K 

As i know its case insensitive. Hence one condition should be enough instead of 3.

[atcodedog05 · Accepted solution]

Hi @Katie_K 

Here is an example

Workflow:

Hope this helps : )

[Katie_K]

Thanks @atcodedog05 good call to just check separately with a small data set!  Cheers.