Data Access User Manual > Rogue Wave 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.

Version 6.3
Copyright © 2018, Rogue Wave Software, Inc. All Rights Reserved.