replace

Returns a string with substrings replaced by new substrings.

Example

replace(INCORTA.ADMIN_EMP.JOB,"Q","Zee")

This example replaces the string “Q” with the string “Zee”.

Syntax

replace(string field, string old, string new)

• field: string to search
• old: string to search for in field

• new: string to replace matching string in old with in field

  Returns

  string

Notes

replace searches string field for the specified characters in old and replaces them with other characters from new.