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 |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |