SUBSTITUTE function

SUBSTITUTE replaces old text with new text in a string.

Syntax

SUBSTITUTE (text,old,new,which)

Example

SUBSTITUTE("123123123","3","abc") returns 12abc12abc12abc.

SUBSTITUTE("123123123","3","abc",2) returns 12312abc123.




Trademarks | IBM Connections wiki