Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Case test functions

There is no straightforward way to know if a string is lower, upper or title case. A workaround such as Contains function or REGEX ones has to be used.

 

The creation of the following functions would make it easier :

     - IsTitleCase(String) : tests if a string is in TitleCase

     - IsUpperCase(String) : tests if a string is in UpperCase

     - IsLowerCase(String) : tests if a string is in LowerCase

They would all return a boolean and be in the Test category.

4 Comments
KylieF
Alteryx Community Team
Alteryx Community Team

Thank you for your feedback! I've added an extra label to this idea to insure all the correct product teams see it. For anyone interested in this idea be sure to check out our Submission Guidelines which go over the idea boards in a bit greater detail.

SeanAdams
17 - Castor
17 - Castor

Hey @Jean-Balteryx ,

 

As you say - because Alteryx doesn't have in inbuilt way of doing case-sensitive equality checks - the simple solution doesn't work

  • if (UpperCase([mystring]) == [mystring]) then...
  • or if (TitleCase([mystring]) == [mystring])

 

I do agree that a test function like "isUpper" would be more obvious; and would also be good to have a way of doing EXACT string matches rather than having to do a regex Match (like @NicoleJohnson mentioned in her post here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Case-sensitive-string-comparison/td-p/...)

 

 

 
 
Emmanuel_G
13 - Pulsar

To quickly check if we are on upper or lower case, you can use an if condition such as iif(regex_match([String_Field],"[a-z]",0),"Lower","Upper"). With the 0 as last argument, we're sure that the mapping is only with lower characters or upper if you write [A-Z].

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes