STR REPLACE()

From Recital Documentation Wiki
Revision as of 14:25, 21 July 2010 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to search for and replace text within a character string or memo field


Syntax

STR_REPLACE(<expC1>, <expC2>, <expC3> | <memofield> [, <expN>])


See Also

AT(), ATNEXT(), CHRTRAN(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), SET STRESCAPE, STR(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()


Description

The STR_REPLACE() function will search <expC3> or <memofield> and replace text within <expC3> or <memofield> with <expC2> wherever the occurrence of <expC1> is found. The STR_REPLACE() function returns a character expression that contains the result of the string replacement.

The optional count argument, <expN>, can be used to return the number of matched and replaced <expC1> strings.


Example

? str_replace("ello", "i","Hello World",nCount)
Hi World
? nCount
         1


Products

Recital Server, Recital