Trying to set up a logical AND filter

1

Good morning.

I currently have the following filter that works well:

thisRow.Type.Contains([SpOut]) AND thisRow.Word.StartsWith(“e”).

However, upon review, I realized that it was NOT picking up words that started with a capitalized “E”.

My efforts to date have failed to produce the correct results as the filter should pick up words that begin with either an “e” or an “E”.

Any help would be appreciated.

TIA

2 
thisRow.Type.Contains([SpOut]) AND thisRow.Word.Lower().StartsWith(“e”)
3

Thank you very much. I appreciate your help.

4

the standard trick to make your matching non-case-sensitive is to put everything into uppercase before doing the matching.

use the Upper() formula.

max

6

Actually, I would prefer to use ContainsText(), which has an ignore case option (and ignore accents if you need that too):

thisRow.Name.ContainsText(thisRow.Text,true)

image