.convert_name and .convert_code Macros

These macros convert the object name to its code (or vice versa).

Use the following syntax to convert a name to a code:

.convert_name (expression[,"separator"[,"delimiters"],case])

Use the following syntax to convert a code to a name:

.convert_code (expression[,"separator"[,"delimiters"]])

The following parameters are available:

Parameter

Description

expression

Specifies the text to be converted. For .convert_name, this is generally the %Name% variable and may include a suffix or prefix.

Type: Simple template

separator

[optional] Character generated each time a separator declared in delimiters is found in the code. For example, "_" (underscore).

Type: Text

delimiters

[optional] Specifies the different delimiters likely to exist in the input code or name, and which will be replaced by separator. You can declare several separators, for example "_ " and "-"

Type: Text

case

[optional for .convert_name only] Specifies the case into which to convert the code. You can choose between:
  • firstLowerWord - First word in lowercase, first letters of subsequent words in uppercase
  • FirstUpperChar - First character of all words in uppercase
  • lower_case - All words in lowercase and separated by an underscore
  • UPPER_CASE - All words in uppercase and separated by an underscore