Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
AnnaEKinch
Partner - Contributor III

Wildmatch "LEFT"

Hi!

I want to get data but non- case sensitive.

In my script below I only get case-sensitive data ie only posts with 'u0' or "EMW". But I need all posts irrespective of case. I figured it should be possible using WILDMATCH but I can't get my head around it. Anyone can help?

If (left("NOTE_TEXT",3)= 'EMW', 'In progress',

If ((left("NOTE_TEXT",2)= 'u0'),'In progress',

1 Solution

Accepted Solutions
jbhappysocks
Creator II

Hi, use Upper

If (upper(left("NOTE_TEXT",3))= 'EMW', 'In progress',

If ((upper(left("NOTE_TEXT",2))= 'U0'),'In progress',

View solution in original post

2 Replies
jbhappysocks
Creator II

Hi, use Upper

If (upper(left("NOTE_TEXT",3))= 'EMW', 'In progress',

If ((upper(left("NOTE_TEXT",2))= 'U0'),'In progress',

AnnaEKinch
Partner - Contributor III
Author

Wonderful! Smart! Thank you soooo much!