/
SUBSTITUTEALL

SUBSTITUTEALL

Owned by Juliane Wetzel
Last updated: May 10, 2023 by Konsta Danyliuk (Deactivated)

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

Related content

SUBSTITUTEALL
SUBSTITUTEALL
Datameer X v10
More like this
SUBSTITUTEALL
SUBSTITUTEALL
Datameer v7
More like this
SUBSTITUTEFIRST
SUBSTITUTEFIRST
Datameer X v10
More like this
SUBSTITUTEFIRST
SUBSTITUTEFIRST
Datameer X v11
More like this
SUBSTITUTEFIRST
SUBSTITUTEFIRST
Datameer v7
More like this
REPLACE
REPLACE
Datameer X v10
More like this