Hi Community,
I like to check if the message I receive is "OK" in a IF condition. But I would like it case insensitive so that "ok" is acceptable as well.
Any idea how?
Hi Alvin,
You can compare ToLower(Message) = ToLower("Ok").
In this way, you ensure you are comparing lower case with lower case.
Hope it helps.
Cheers,
João
João Marques wrote:
Hi João
Will the above work for the following "OK", "Ok", "ok", "oK"?
In addition to João solution statement, I would also suggest you to use Trim pre-defined function (to remove additional white spaces) in case of string value comparison
ToLower(Trim(Message)) = ToLower("Ok")
Regards,
Benjith Sam
Benjith Sam wrote:
Thanks Benjith!