Looking to use Regex in Value Mapper

Digital_BP
Digital_BP
in Data Platform & Data Science

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

  • Chronos
    Chronos ⚪️

    Is anyone able to help out with this request?

  • Gimli
    Gimli

    domo

    💎

    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. 

    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • IamJJ
    IamJJ 🟡

    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...

Categories