ADELIA |
VADELIA |
SADELIA |
WADELIA |
EADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(B) |
Description
This predefined function is used to transform a character string in accordance with two conversion strings (origin and target).
If a character in the string to be transformed exists in the original string, the corresponding character in the target string is transferred into the result field.
Characters not found in the original string are copied into the result field without being changed.
Syntax
Result = &TRANSFORMATION(String;Transformation;Transformation)
origin |
target |
Parameters
Description |
Contents |
Controls |
|
Result |
Alphanumeric |
Transformed character string. The result field is cleared before the function is run. |
|
String |
Alphanumeric variable or constant. |
Character string to be transformed. |
Mandatory parameter. |
Origin transformation |
Alphanumeric variable or constant. |
Characters to be transformed. |
Mandatory parameter. |
Target transformation |
Alphanumeric variable or constant. |
Replacement characters. |
Mandatory parameter. |
Example
STRING = 'DISCOUNT AGREEMENT: 25% SIGNED WITH MR JOHN GRANT' |
|
ORIGIN = |
'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890%+-.' |
TARGET = |
'.-+%0987654321ZYXWVUTSRQPONMLKJIHGFEDCBA' |
CODED_STRING = &TRANSFORMATION(STRING;ORIGIN;TARGET) |
|
* |
|
* CODED_STRING is equal to: %6V+ZT1U .8W00201U: MJD V6810% R6U7 2W 5Z71 8W.1U |
|
STRING = 'ADELIA C/S: secure the present, evolve to the future' |
|
ORIGIN = |
'abcdefghijklmnopqrstuvwxyzéèàùâêîôû' |
TARGET = |
' ABCDEFGHIJKLMNOPQRSTUVWXYZEEAUAEIOU ' |
NEW_STRING = &TRANSFORMATION(STRING;ORIGIN;TARGET) |
|
* |
|
* The NEW_STRING is equal to: |
|
ADELIA C/S: SECURE THE PRESENT, EVOLVE TO THE FUTURE |
|
List of predefined functions by topic