PowerCenter
- PowerCenter 10.5
- All Products
REG_REPLACE(subject,pattern,replace,numReplacements)
Argument
| Required/
Optional
| Description
|
---|---|---|
subject
| Required
| String datatype. Passes the string you want to search.
|
pattern
| Required
| String datatype. Passes the character string to be replaced. You must use perl compatible regular expression syntax. Enclose the pattern in single quotes. For more information, see
REG_EXTRACT.
|
replace
| Required
| String datatype. Passes the new character string.
|
numReplacements
| Optional
| Numeric datatype. Specifies the number of occurrences you want to replace. If you omit this option, REG_REPLACE will replace all occurrences of the character string.
|
REG_REPLACE( Employee_Name, ‘\s+’, ‘ ’)
|
|
---|---|
|
|
|
|
|
|
|
|