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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

amitchandak thank you very much for replying. It is an honor to have you help me. I have admired your knowledge and willingness to help others for a long time. That looks great and I can use it 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. That way I will be able to find constituents who have any fields that are all upper case.

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , As of now, I think you need to have the same condition on all columns using or (||)

 

for and we can even concat and check

 

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    amitchandak I tried this, but get a "no" when the "IQ" last name should give a "yes" result.

     

    Final =
    IF (
        [FirstName] = BLANK ()
            && [LastName] = BLANK (),
        BLANK (),
        IF(
    EXACT(UPPER('132330'[Prefix] &'132330'[FirstName] &'132330'[LastName] &'132330'[Suffix] &'132330'[PreferredName] &'132330'[HomeAddress1] &'132330'[HomeAddress2] &'132330'[HomeCity] & '132330'[Email]) , '132330'[Prefix] &'132330'[FirstName] &'132330'[LastName] &'132330'[Suffix] &'132330'[PreferredName] &'132330'[HomeAddress1] &'132330'[HomeAddress2] &'132330'[HomeCity] & '132330'[Email])
    , "yes", "no"))
    • v-zhangti's avatar
      v-zhangti
      Community Support
      3 years ago

      Hi, Anonymous 

       

      You can try the following methods.

      Uppercase = 
IF (
    [FirstName] = BLANK ()
        && [LastName] = BLANK (),
    BLANK (),
    IF (
        EXACT ( UPPER ( '132330'[FirstName] ), '132330'[FirstName] )
            || EXACT ( UPPER ( '132330'[LastName] ), '132330'[LastName] )
            ||EXACT ( UPPER ( '132330'[Name] ), '132330'[Name]),
        "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.