
Partner - Contributor III
2021-06-22
04:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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',
906 Views
1 Solution
Accepted Solutions

Creator II
2021-06-22
05:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, use Upper
If (upper(left("NOTE_TEXT",3))= 'EMW', 'In progress',
If ((upper(left("NOTE_TEXT",2))= 'U0'),'In progress',
885 Views
2 Replies

Creator II
2021-06-22
05:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, use Upper
If (upper(left("NOTE_TEXT",3))= 'EMW', 'In progress',
If ((upper(left("NOTE_TEXT",2))= 'U0'),'In progress',
886 Views

Partner - Contributor III
2021-06-22
05:13 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wonderful! Smart! Thank you soooo much!
870 Views
