Hello.
query, mapping, Red_wine, Wine, Bar_ton, category_texas, USA, United, American
Above is the data I have, I would like to get the data after category_ and the result should be Texas. What’s the best way to achieve it???
Thank you
You could try a Text parser module.
The result, with your example as input, would be:
The Pattern may need to be refined after seeing a larger example set.
You can test the pattern on a regular express testing website, like Regex101.com
Just be sure to select ECMAScript (JavaS…) on the left hand side under FLAVOR.
2 Likes