Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
col |
A |
B |
3 |
10 |
if(contains(toUppercase(col),"A"),"letters",
if(contains(toUppercase(col),"B"),"letters",
"others"))
The code above works but is it possible to shorten it to combine the logic for "A" and "B"?
For example in the syntax below (albeit incorrect):
if(contains(toUppercase(col),"A" or "B"),"letters",
"others")
It's possible but not going to help you simplify the expression. Using the boolean operators:
if(contains(toUppercase("ABC"),"D") || contains(toUppercase("ABC"),"A"), "letters", "others")
Or using boolean functions:
if(or(contains(toUppercase("ABC"),"D"), contains(toUppercase("ABC"),"A")), "letters", "others")
You will be better using match() with a regular expression and check the output with length().
It's possible but not going to help you simplify the expression. Using the boolean operators:
if(contains(toUppercase("ABC"),"D") || contains(toUppercase("ABC"),"A"), "letters", "others")
Or using boolean functions:
if(or(contains(toUppercase("ABC"),"D"), contains(toUppercase("ABC"),"A")), "letters", "others")
You will be better using match() with a regular expression and check the output with length().