Case sensitivity when using IF-THEN-ELSEIF within Formula Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @atcodedog05 good call to just check separately with a small data set! Cheers.
