repstr(X;L)
Returns the given string with substrings replaced based on a given list of string pairs.
Syntax
repstr(X;L)
Input
Argument | Type | Description |
---|---|---|
X |
text | The string on which to apply the function A column name |
L |
text | A space- or comma-separated list of pairs of text strings where
L has the form: 'old1' 'new1' 'old2'
'new2' ...'oldx'
'newx' |
Return Value
Returns the text string X
with substrings in X
replaced
based on the string pairs specified in the list L
.
If X
is N/A, the result is N/A.
Sample Usage
value |
list |
repstr(value;list) |
---|---|---|
'abcdefg' | 'bc' 'RS' 'ef' 'xy' | 'aRSdxyg' |
'banana' | 'ana' 'ANA' 'b' '' | 'ANAna' |
Example
In the "Product Master" table (pub.demo.retail.prod), let's say we
wanted to replace the occurrences of "OZ" with
"OUNCE" in the itemdesc
column. To do this, we
could create a computed column and use the repstr(X;L)
function, specifying
the itemdesc
column name for the X
parameter and the
replacement pair of strings 'OZ' and 'OUNCE'
in the list for the L
parameter.
<base table="pub.demo.retail.prod"/> <willbe name="repstr_results" value="repstr(itemdesc;'OZ' 'OUNCE')"/> <colord cols="itemdesc, repstr_results"/>
In this example, the value of "PEPSI 20 OZ" has been changed to "PEPSI 20 OUNCE".