Initializing help system before first use

regreplace

Purpose
Replace portions of a text string based on a regular expression.
Synopsis
function regreplace(src:text, regex:string, repl:string):integer
function regreplace(src:text, regex:string, repl:string, start:integer, flags:integer):integer
Arguments
src 
Text to process
regex 
Regular expression
repl 
Replacement string expression
start 
Position where to start the search
flags 
Search options:
REG_EXTENDED 
Use Extended Regular Expression syntax (ERE), default is to interpret the expression as a Basic Regular Expression (BRE)
REG_ICASE 
Comparison is performed case insensitive (by default it is case sensitive)
REG_NEWLINE 
The character newline ( \n) is treated as the end of line (by default it is handled as an ordinary symbol)
REG_NOTBOL 
The beginning of the text string is not the beginning of a line
REG_NOTEOL 
The end of the text string is not the end of a line
REG_ONCE 
Stop after the first replacement (by default the entire input string is processed)
Return value
The number of replacements performed.
Example
The following statement transforms dates expressed as year-month-day to dates in the form day/month/year 
nbr:=regreplace(t,
      '([[:digit:]]{4})-([01]?[[:digit:]])-([0-3]?[[:digit:]])',
      '\3/\2/\1',1,REG_EXTENDED)
Further information
1. This function relies on the TRE library (see http://laurikari.net/tre). Please refer to the documentation of this library for a detailed description of the supported expression syntax.
2. In the replacement string repl the backslash character ( '\') has a special meaning: if followed by another baskslash character it is replaced by a single backslash; if followed by a digit it is replaced by the corresponding subexpression defined by the regular expression. The subexpression number 0 corresponds to the entire matching region.
Related topics
regmatch, sys_regcache
Module
mmsystem

Parent Topic Procedures and functions

© 2001-2025 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.