Problem of ValuesMapping with regex.


Question.

I would like to modify Contact Email before insert/update it on target org and replace ".", "-", "@" with "_" but my regex seems to find records to update. I tried also the js way with evaluate but this doesn't work either. My regex seems to be ok where am I wrong?

My ValueMapping.csv is as following:

ObjectName,FieldName,RawValue,Value
Contact,Identite_digitale__c,2,1
Contact,Email,/([.,@-]+)/,_

Answer.

You should enclose the regex expression in the double-quotes to be recognized as a single string value:

ObjectName,FieldName,RawValue,Value
Contact,Identite_digitale__c,2,1
Contact,Email,"/([.,@-]+)/",_

It's strongly recommended to do that for all csv values.

Here you also have comma in the regex which is confusing the Plugin to recognize "/([." and "@-]+)/" as 2 values belonging to 2 different columns.

Last updated on 29th Jan 2023