SUBSTITUTE Function
Description: Return a string that replaces all occurrences of a regular expression with the replacement string specified.
Parameters: String, String, String
- Source text: The string containing the source value.
- Expression: The java regular expression that will be used to locate the characters to be replaced.
- New text: The replacement value. This string can be a different length than the string being replaced.
Return: String containing the modified value.
Syntax: SUBSTRING1 (<source text>,<expression>,<new text>)
Example: Set String 8 sub to the value from String 8 after replacing all the numbers within the value with “*”.
DE("String 8 sub").setValue
( SUBSTITUTE( DE("String 8").getValue( ), "[0-9]", "*" ) );
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*