Getting value from a list


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

Just be sure to select ECMAScript (JavaS…) on the left hand side under FLAVOR.