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.