SOLVED
How to flag a record if a concatenated string contains something OTHER THAN a given value?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
csh8428
11 - Bolide
‎03-09-2023
12:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm trying to figure how to flag a record if a concatenated string contains something OTHER THAN a given value. I don't know all the values a cell may have, otherwise I would just use a contains and search for those values to flag it.
For example:
I want to flag a cell if it contains ANY value OTHER THAN just "A".
Field value: A,B,A,C,D,G,H. <-- this would be flagged
Field value: A,A,Z <-- this would be flagged
Field value: A,A,A,A,A <--this would NOT be flagged
Thanks,
Craig
Solved! Go to Solution.
Labels:
- Labels:
- Help
- Preparation
3 REPLIES 3
17 - Castor
‎03-09-2023
01:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
14 - Magnetar
‎03-09-2023
01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
flying008
15 - Aurora
‎03-09-2023
04:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
