Start a new topic

Regex Help - Importing 1 value and ignore others

Hi.  


We have a field we want to import to Re, which we want to create a constituent attribute for just 1 value and ignore the rest.

we have tried to create a Regex which imports blank for all values except for the one we want, but its not working and the import spits exceltions - any help?


import values "Incorrect Number" - add a table entry in a constituen attribute

ignore other values "Refusal"; "Conversion" "Not Contactable"


Thanks

Erin

1 Comment

Hi Erin,


I think this article might help you.


https://iom.uservoice.com/knowledgebase/articles/841260-how-to-use-virtual-fields-to-populate-a-field-only


I think if you will build up 2 layered dictionary first making string between importing values and outcome attribute in RE adding ^.+$ as second layer you might be able to achieve what you need after applying dictionary to mapped field.


Login or Signup to post a comment