Hi hive mind!

We are using an import file, which unhelpfully has all the main four options of contact preference (post, telephone, text, email) concatenated together looking like this:

I have managed to regex a dictionary using:

.*telephone

to apply "Yes to telephone" in the constituent attributes, however I now need the opposite, so I need "if field does not contain telephone" so I can add "No to telephone".

Can anyone help please?

Many thanks

Gemma

Hi Gemma

Since the first line is converting anything that contains telephone to the string "Yes to telephone" then the next line will need to search for anything that doesn't contain that.  So your value to match on would be  ^(?!Yes to telephone).*$ 

Thanks,

John

Many thanks for your help John!