Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Syntax

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

Description

Substitutes new text for the first occurrence of the old text in a text string.

Examples

StringSearch stringNew stringSUBSTITUTEFIRST returns
searchnomatchreplacementsearch
searchsearchreplacementreplacement
search searchsearchreplacementreplacement search
  • No labels