Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Function Index > S

SRPL

Scroll Prev Top Next More

(SRPL(sourcestring,searchstring,replacestring,[0|1]))

 

Enables searching for and replacing text within a specified string of text.

 

sourcestring - specifies a string of text to search

searchstring - specifies text to search for

replacestring - specifies the replacement text

flag - 0 = replacement occurs for every matching string

     - 1 = replacement occurs for whole word matches only

     

 

The following "0 flag" example replaces 04/20/64 with 04-20-64:

 

SET VAR vsrpl = (SRPL('04/20/64','/','-',0))

 

The following "1 flag" example replaces Dear Joe with Dear Anne:

 

SET VAR vsrpl = (SRPL('Dear Joe','Joe','Anne',1))

 

However, with this next "1 flag" example DearJoe remains the same as DearJoe is a whole word without a space.

 

SET VAR vsrpl = (SRPL('DearJoe','Joe','Anne',1))