Hope someone can assist here.

I have a LONG TEXT field which holds the extract of a XML file. I want to be able to report on this field inside a saved search, extracting the value of the ‘Country’ tag.

Example below:

I tried this particular regex expression and with no luck:

REGEXP_SUBSTR({custrecord_xml}, ‘<Country>([^<]+)</Country>’, 1, 1, NULL, 1)

Can you identify what I am doing wrong here?