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

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.