Hi All,
I have a single text field that i hope to record multiple values in.
I then wish to display each of these values in a separate column on a search.
A way i thought of doing this was to surround each of the values that i wish to output in the search in different custom tags then extract the values using a regex formula.
e.g. In the text field i want to put something like:
<tag1>value1</tag1><tag2>value2</tag2><tag3>value3</tag3>
Then in my saved search i would create three results columns of type formula numeric and extract each of the values as follows:
TO_NUMBER(REGEXP_SUBSTR({custcol_comment_field},'< tag1>(.*)</tag1>')) - For numerical values
REGEXP_SUBSTR({custcol_comment_field},'<tag2>(.*)</tag2>') - Text Values
etc.
I have tested the regex expression on regexr.com and it is correct and should get the value im looking for.
However when i use this formula the results are empty.
Would anyone have any reason as to why the results here are empty?
The other option would be to create additional fields - however we would like to avoid doing this if possible.
Thanks in advance for any help!