Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Check if 2 text values are the same

Topic Labels: Data
Solved
Jump to Solution
567 4
cancel
Showing results for 
Search instead for 
Did you mean: 
INCOSEIL
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi

I would like to compare 2 text fields. The first in "Internal" and the second is "External".

I saw this solution

https://community.airtable.com/t5/formulas/comparing-of-two-values-in-rolled-up-fields-and-showing-t...

IF( ARRAYJOIN({Internal}, {Internal}) = {External}, 
  "same", 
  "different"
)

which works only if the text fields are excatly the same including lower and apper case. ,eaning it is case sensitive.

I am looking for a non case sensetive solution.
IF( LOWER(ARRAYJOIN({Internal}, {Internal})) = LOWER({External}), "same", "different" )

but "= LOWER({External})" is illigel

How can I use

IF( ARRAYJOIN({Internal}, {Internal}) = {External}, "same", "different" )

to be non case sensetive?

 

 

 

1 Solution

Accepted Solutions
INCOSEIL
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi James

Thank you but in case one or more of the fields is not plan text then I won't work since apperentaly Airtable does not see Lookups as texts but as references.

A solution is to add CONCATENATE before the lookup field.

 

IF(CONCATENATE(LOWER({Internal})) = LOWER({External}),
"same",
"different"
)


Thanks

 

See Solution in Thread

4 Replies 4
INCOSEIL
5 - Automation Enthusiast
5 - Automation Enthusiast

I also tried:

SEARCH(LOWER({Internal}),LOWER({External}))

it should yeild 1 if the strings are identical but this results in error.

INCOSEIL
5 - Automation Enthusiast
5 - Automation Enthusiast

I found the solution.

The prolem seems to be that Airtable doesn't store lookup fiels as text (the internal was not text but lookup)

so this is the solution:

IF(SEARCH(LOWER(CONCATENATE({internal})),LOWER(external)),"Good","Not Good").
 
CONCATENATE({internal}) transforns the field to text.
LOWER(CONCATENATE({internal})) and LOWER(external) transforms all to lower case
 
ans search function compers them (returs 1 if identical).
jamesnevada
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

Glad to hear you found a solution. It seems to me though that this is a more complex formula then it needs to be.

Did you try just doing this:

IF(LOWER({Internal}) = LOWER({External}), 
  "same", 
  "different"
)
INCOSEIL
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi James

Thank you but in case one or more of the fields is not plan text then I won't work since apperentaly Airtable does not see Lookups as texts but as references.

A solution is to add CONCATENATE before the lookup field.

 

IF(CONCATENATE(LOWER({Internal})) = LOWER({External}),
"same",
"different"
)


Thanks