Caché MultiValue Basic Reference
CONVERT
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Replaces single characters in a string.
Synopsis
CONVERT(remove,replace,string)
Arguments
remove One or more characters to be removed and replaced. An expression that resolves to a string or numeric.
replace One or more characters to be inserted in place of the corresponding characters in remove. An expression that resolves to a string or numeric.
string The string in which character substitutions are made. An expression that resolves to a string or numeric. string may be a dynamic array.
Description
The CONVERT function edits the value of string by replacing all instances of each single character in remove with the corresponding single characters in replace and returning the resulting string. CONVERT performs a character-for-character substitution. Matching of characters is case-sensitive.
CONVERT can be used as follows:
The value of remove and replace can be a string or a numeric. If numeric, the value is converted to canonical form (plus sign, leading and trailing zeros removed) before performing the CONVERT operation.
If remove contains more characters than replace, the unpaired characters are deleted from the returned string. If replace contains more characters than remove, the unpaired characters are ignored and have no effect.
Note:
CONVERT performs single character one-for-one substitution for all instances in a string. The CHANGE function performs substring replacement, and can specify how many instances to replace and where to begin replacement.
The CONVERT statement and the CONVERT function perform the same operation, with the following difference: the CONVERT statement changes the supplied string; the CONVERT function returns a new string with the specified changes and leaves the supplied string unchanged.
Emulation
The order of the CONVERT arguments differs in different emulation modes. In Caché MVBasic, the order is remove,replace,string. In MultiValue emulation modes, the argument order is as follows:
Examples
The following example illustrates use of the CONVERT function in converting a string to a dynamic array by replacing the # character with a Value Mark level delimiter character:
cities="New York#Chicago#Boston#Los Angeles"
dynacities=CONVERT("#",CHAR(253),cities)
PRINT cities
PRINT dynacities
See Also