Using REPLACEREGEX with Scribe's field formula

[Stephen Outram]

I have address data that looks like this,

defaultAddress: NameStreetCity ZIPCountry

In my flow's insert/update block 'Country' field, I'm using the following REGEX to match everything that is not the country name and replace it with blank "". The targetis to delete everything and leave the country name.

REPLACEREGEX(Customer.defaultAddress, "([^>]*>)/gm", "")

When I test this REGEX (https://regexr.com/) it matches everything that is not the country name. Great!

([^>]*>)/gm

But when I process it in Scribe's flow Debug Mode, the result for Country is the full defaultAddress.

Any thoughts on how this could work

Thanks, Stephen

[Stephen Outram]

Interestingly, after posting my question, the answer showed up.

Using this .NET REGEX tester http://regexstorm.net/tester revealed /gm was not required.

The final working formula, REPLACEREGEX(Customer.defaultAddress, "[^>]*>", "")

Cheers!