SUBSTITUTEALL

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

Syntax

SUBSTITUTEALL(<string>; <search string>; <new string>)

Description

Substitutes new text for all occurrences of old text in a text string.

Examples

StringSearch stringNew stringSUBSTITUTEALL returns
searchnomatchreplacementsearch
searchsearchreplacementreplacement
search searchsearchreplacementreplacement replacement