Forum Discussion
Find upper case string in multiple columns
I learned how to use this and it works for one column.
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.
13 Replies
Anonymous , You have add a condition with add && , OR ||
example
IF(
EXACT(UPPER('132330'[FirstName]), '132330'[FirstName]) || EXACT(UPPER('132330'[LatsName]), '132330'[LastName])
, "yes", "no")with and
IF(
EXACT(UPPER('132330'[FirstName]), '132330'[FirstName]) && EXACT(UPPER('132330'[LatsName]), '132330'[LastName])
, "yes", "no")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.
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")
amitchandak can this be combined with some of this code below at the beginning to not include empty cells giving a "yes" anwser?
Uppercase =
IF (
[FirstName] = BLANK ()
&& [LastName] = BLANK (),
BLANK (),
IF (
EXACT ( UPPER ( '132330'[Prefix] ), '132330'[Prefix] )
&& EXACT ( UPPER ( '132330'[FirstName] ), '132330'[FirstName] ),
"yes",
"no"
)Anonymous , Try like
Uppercase =
Switch(True(),
[FirstName] = BLANK ()
&& [LastName] = BLANK (),
EXACT ( UPPER ( '132330'[Prefix] ), '132330'[Prefix] )
&& EXACT ( UPPER ( '132330'[FirstName] ), '132330'[FirstName] ),
"yes",
"no"
)
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 thank you very much for the method to remove the false result when the Prefix field is empty.
That worked!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.
amitchandak I am using this for a single column. When filtering a slicer to show "yes" results it is returning numbers as all uppercase values. Is there a way to remove them?
