Display Formats for Strings
When defining the layout of fields with data type String, it is possible, although not usual, to apply a display format.
The display format codes for fields with data type String are limited because string data is normally expected to be displayed in its entirety. If more extensive formatting is required, use string manipulation and substitution functions to assemble the string, and then assign it to a field.
?: Alphanumeric character
Display a character from the input string.
| Input Value | Formatted Value |
|---|---|
| Plato | Plato |
| Socrates | Socrat |
Any ASCII character
Each ASCII character as a constant; can only be used in combination with another string display format .
| Input Value | Formatted Value |
|---|---|
| Plato | Mr. Plato |
| Socrates | Mr. Socrat |
%?: Escaped question mark
Display a question mark.
| Input Value | Formatted Value |
|---|---|
| Plato | Mr. Plato? |
| Socrates | Mr. Socra? |
%%: Escaped percent symbol
Display a question mark.
| Input Value | Formatted Value |
|---|---|
| 100 | 100% |
| 80 | 80 |
