Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Find upper case string in multiple columns

I learned how to use this and it works for one column.    Uppercase = IF(     EXACT(UPPER('132330'[FirstName]), '132330'[FirstName])         , "yes", "no")   Is it possible to edit it so it ...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    Column:

    Uppercase =
IF (
    [FirstName] = BLANK ()
        && [LastName] = BLANK (),
    BLANK (),
    IF (
        EXACT ( UPPER ( '132330'[FirstName] ), '132330'[FirstName] )
            && EXACT ( UPPER ( '132330'[LastName] ), '132330'[LastName] ),
        "yes",
        "no"
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

Column:

Uppercase =
IF (
    [FirstName] = BLANK ()
        && [LastName] = BLANK (),
    BLANK (),
    IF (
        EXACT ( UPPER ( '132330'[FirstName] ), '132330'[FirstName] )
            && EXACT ( UPPER ( '132330'[LastName] ), '132330'[LastName] ),
        "yes",
        "no"
    )
)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    v-zhangti thank you very much for the method to remove the false result when the Prefix field is empty.
    That worked!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    v-zhangti thank you very much for replying. That looks great and I can use in other applications, but I am wanting to have the result to return "yes" if any of the values in a row are all upper case. In your example, all rows would return "yes". That way I will be able to find constituents who have any fields all upper.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    @Community Support Team _Charlotte I was looking to get a "yes" result if the value in any of the columns was all upper case even if the other columns in the row weren't.