Unanswered

Convert to Lower/Upper Case (@contains)

(1) Share

Report

Posted on by ovetteabejuela

I observed that text comparison for 'contains' is case-sensitive. how can I convert to Upper/Lower case so that I still get the exact match regardless of case.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Masterkeys 31 on at

Like (3)

Report
Copy link

Link copied!

Use the function toUpper or toLower as appropriate

Was this reply helpful? Yes No

v-micsh-msft Microsoft Employee on at

Like (1)

Report

Copy link

Link copied!

Adding the function reference:

toLower

Converts a string to lowercase. For example, this function returns two by two is four:

toLower('Two by Two is Four')

Parameter number: 1

Name: String

Description: Required. The string to convert to lower casing. If a character in the string does not have a lowercase equivalent, the character is included unchanged in the returned string.

toUpper

Converts a string to uppercase. For example, this function returns TWO BY TWO IS FOUR:

toUpper('Two by Two is Four')

Parameter number: 1

Name: String

Description: Required. The string to convert to upper casing. If a character in the string does not have an uppercase equivalent, the character is included unchanged in the returned string.

From here.

Regards,

Michael