Substitutes all characters in a string, that are not included in the selected character set, with a replacement character.
Some payment system , such as BACS, don;t allow certain characters. This node can be used to substitute any character that the payment system does not allow with a replacement character. This prevent ‘illegal’ characters appearing in the payment file and potentially causoing the payment to fail.
Examples
MICHAEL O'FLATLEY => MICHAEL O FLATLEY
Note
This node is very strict and will also substiture lower case letters -because BACS does not allow lower case letters. Place a ‘To Uppercase’ node in front of the Substitute node to prevent over substituting the input string.
