Looking to use Regex in Value Mapper

We have a column with the following example string:

holiday home insurance_E

 

We need to search for any string with the _E at the end and update a Match Type column using Value Mapper with 'Exact'

 

We have tried using RegEx ^[\w|\s]+_E$ which correctly identifies the string but the value mapper is not updating the column or recognising the value.

 

Any thoughts on how we can accomplish this?

Comments

  • Is anyone able to help out with this request?

  • Hello @Digital_BP

    This is hard to describe over the dojo without having an example ETL. I will send you an email to work with you in solving this. 

  • was this solved for you?  I am trying to perform a similar parse of a text string and this is the closest I've found to what I'm looking to do...