replace()

Read(710) Label: replace, source string, substring,

Description:

Replace a specified substring of a source string.

Syntax:

replace (src,a,b)

Note:

The function replaces the substring a of string src with another string b.

Parameter:

src

Source string

a

The substring of a source string

b

The string with which the specified string will be replaced

Option:

@q

A quoted specified string won’t be replaced

@1

Enble to replace the first-found specified substring only

@c

Case-insensitive

Return value:

A string after the replacement

Example:

replace("123321","2","two")

1two33two1

replace("abc'abc'def","a","China")

Chinabc'Chinabc'def

replace@q("abc'abc'def","a","China")

Chinabc'abc'def; the “a” enclosed by the single quotes are not replaced

replace@1("abcabcdef","a","China")

Chinabcabcdef; only the first “a” is replaced

replace@c("abcabcdef","A","China")

ChinabcChinabcdef; case-insensitive