After installation, the Descriptionformula will be additionally available to you.
Description
This formula shortens a source text to a maximum length using the abbreviations in the Studio.
If the maximum length is exceeded, the field remains empty.
Source value and abbreviation are case-sensitive and special characters are also taken into account.
Formula(s)
{=ABBREVIATION("Source text";Maximum length;Maximum priority)}
Result
-
String
Parameters
Parameters
|
Contents
|
Format
|
Default value
|
Explanation
|
|---|---|---|---|---|
|
Source text |
Fixed source text or e.g. attribute values via ATTRVAL |
String or formula |
|
|
|
Maximum length |
Maximum number of characters that the attribute may contain. |
Integer |
200 |
Queries the function "greater than", not "greater than or equal to". A value of 200 therefore also means a maximum number of 200. |
|
Maximum priority |
Highest priority from the Studio that may be used. |
Integer |
0 |
Specifies the highest priority that may be used in the abbreviation. |