Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 13, 2023 03:13 PM
Seeking to identify if two numbers match exactly in both fields, such as 22 matching 22, and not partial matches like 2.
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 13, 2023 04:02 PM
How about REGEX?
REGEX_MATCH(ARRAYJOIN({Above 20%}),"(^|,)"& {Hours Number} &"(,|$)")
Reply
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 13, 2023 04:02 PM
How about REGEX?
REGEX_MATCH(ARRAYJOIN({Above 20%}),"(^|,)"& {Hours Number} &"(,|$)")
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 13, 2023 04:10 PM
Thank you greatly, this is precisely what I aimed to achieve.