String Formats

Options > Data Access User Manual > Views Data Access Gadgets > Format Syntax > String Formats

String Formats

String formats apply to the formatting of text.

Symbols

You can use the following symbols to specify a string format:

!	Formatting must proceed from right to left.
<	Characters following the symbol will be converted to lowercase.
>	Characters following the symbol will be converted to uppercase.
@	Placeholder for a mandatory character.
&	Placeholder for an optional character.

Normally, character string formatting proceeds by scanning the character string value and the format specification from left to right. However, if the format specification contains a “!” symbol, then scanning of both the character string value and the format specification proceeds from right to left.

Examples

Value	Format	Result
forms	>	FORMS
FormS	<	forms
forms	<@>	fORMS
forms	<@@>	foRMS
forms	!>@<	FORMs
forms	!>@<@@@>	FoRMS
forms	&&&&&&“data”	formsdata
forms	@@@@@@“data”	forms data

@ symbols are replaced by spaces when there is no corresponding character in the string value.

Published date: 05/24/2022

Last modified date: 02/24/2022