How to compare respecting uppercases and lowercases?
when I compare: “Hola” = “hoLa” the result is TRUE.
This is the expression:
The comparation result is TRUE
Is this behaviour correct? I guess it worked different, respecting the upper and lower cases
How to compare respecting uppercases and lowercases?
Solved! Go to Solution.
One way is FIND([Text1],[Text2])=1 because FIND expression is case sensitive. For example…
FIND(“Hola”,“HolA”)=0 where as FIND(“Hola”,“Hola”)=1
Hi @Fernando_Lopez,
one possible Workaround would be to encode the letters into Numbers like:
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("ABab","A","0"),"B","1"),"a","26"),"b","27")
The letters “ABab” would give 012627.
The letters “AbaB” would give 027261.
The compare result will be FALSE.
For sure - you will have a very long expression, because you have to SUBSTITUTE() every letter. For example: A-Z substitute with 0-25 and a-z substitute with 26-51.
Instead of “ABab” you can put your column name [Texto1] and in the compare expression [Texto2].
One way is FIND([Text1],[Text2])=1 because FIND expression is case sensitive. For example…
FIND(“Hola”,“HolA”)=0 where as FIND(“Hola”,“Hola”)=1
Thank you @Aleksi …
So, comparing in appsheet plataform is NO case sensitive, Isn’t it?
@Aleksi You always know an easier way. Thank you!
Just found this answer. Thank you so much (it’s my very first problem here).
In generally yes… but for example FIND is case sensitive.
Hi @Aleksi,
Using FIND () is a nice workaround.
@Suvrutt_Gurjar Thanks!
You’re welcome, happy to help.
Tahnk you all guys !!!
User | Count |
---|---|
46 | |
29 | |
24 | |
22 | |
13 |