This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Comparing Text

Posted on 11-06-2019 08:40 PM
Fernando_Lopez1
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM

How to compare respecting uppercases and lowercases?

when I compare: “Hola” = “hoLa” the result is TRUE.

This is the expression:
2X_c_cc3a1383d5525ba787cd3cbf3dc62462ba974518.png

The comparation result is TRUE

2X_4_440cfbebd1006c10bdc9dfc72e0e9062103c54e7.png

Is this behaviour correct? I guess it worked different, respecting the upper and lower cases

How to compare respecting uppercases and lowercases?

Solved Solved
0 10 1,206
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Aleksi
Staff
Reply posted on --/--/---- --:-- AM

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

View solution in original post

Jump to Solution
10 REPLIES 10
Top Labels in this Space