Phone Number field is showing '+' as an ASCII '+'


Description

When mapping a string phone number field on record producer to a phone number type field on a table, if a phone number is showing '+' as ASCII value '+'. It can be fixed with an after insert business rule

Instructions

- Create a Business rule on target table


When - After
Insert - True

Script:

(function executeRule(current, previous /*null when async*/) {

var myString = current.<column name of phone number field>;
var newString = myString.replace('&43;', '+');
current.<column name of phone number field> = newString.toString();
current.update();

})(current, previous);