Products Downloads


French version


 


ADELIA

VADELIA

SADELIA

WADELIA

MADELIA

(I/B)

(I/B)

(B)

(I/B)

(I)


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
variable.

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


↑ Top of page

  • Aucune étiquette