Hi friends!
I'm looking to create a formula to validate whether a string follows a set pattern.
Each book I'm referencing has a set number. This is the specific pattern: "[BOOKS]" + "b" + 3 digit number e.g. [BOOKS]b123
- Values can be comma delimited
- No limit to number of books that can be listed
Here are some examples of cell values and expected outcome of PASS/FAIL.
1. [BOOKS]b123 > PASS
2. [BOOKS]b12 3 > FAIL
3. [BOOK]b123 > FAIL
4. [BOOKS]b123,[BOOKS]b567,[BOOKS]b876 > PASS
5. Bonus if I can get it to FAIL if there is a duplicate
I know it is possible to do this via RegEx, but is there a way to create a formula that does the same validation?
Thank you!
Bookmarks