REPLACE_ALL Function

Description: Replaces all occurrences of the “Find text” with the “New text”. The new value and the old value do not have to be the same length. The replacement proceeds from the beginning of the string to the end. For example, replacing "aa" with "b" in the string "aaa" will result in "ba" rather than "ab". This function is case sensitive; the “Find text” must be an exact match for the “Source text”. Use the UPPER_CASE or LOWER_CASE functions to adjust the case, if necessary.

Parameters: String, String, String

  • Source text: The string containing the source value.
  • Find text: The string containing the value to find.
  • New text: The string containing the replacement value.

Return: String containing the modified value.

Syntax: REPLACE_ALL (<source text>,<find text>,<new text>)

Example: Set the value in String 4 replace to the value from String 4 after replacing all occurrences of “com” with “**”.

DE( "String 4 replace" ).setValue

  ( REPLACE_ALL( DE( "String 4" ).getValue( ), "com", "~*~*" ) );

{{export-indexterm primary="REPLACE_ALL function"/}}

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*