I have a column with name of failure, which contains all variety of strings. I like to search error code with start of "ex". the error code is 10-character string with start of "ex". and put the 1st error code into column of "1st code", all error codes into column of "all codes. what formula is set to both columns? sorry to bother again. I need to quickly make my work in hands closed firstly, then take time to learn JMP help document.
I don't have proper definition on your error codes so I cannot provide good patterns to start with. I only know it starts with 0x but I would need to know allowed characters, is there any order for these allowed characters and how to determine when it ends (and length if there is one).
today I took some time to read the Definition and Examples of the Regex() function is found in the Scripting Index, and learned Regex pattern structure like ([a-zA-Z])\s([0-9]). it's wonderful sharing that using https://regex101.com/ tests the regex patterns.
Regex() or Regex match() is a little complicated function. I need to find more examples from the community to practice the usage of Regex(). thank you very much for your sharing of the links.