13-34
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 M anaging Reports
Formatting Reports in Interactive Viewer
415-555-2121
You can create custom formats for string data. Table 13-8 describes the symbols you can use to define
custom string formats
.
Table13-9 shows examples of custom string format patterns and their effects on text data.
Step1 Select a string data column, then click Format.
The String column format window appears.
Step2 In Format String as field, select Custom.
A second field, Format Code, appears.
Step3 In the Format Code field, enter a format pattern such as those shown in Table 13 -9.
Table13-8 Symbols for Defining Custom String Formats
Symbol Description
@ Character placeholder. Each @ character displays a character in the string. If the
string has fewer characters than the number of @ symbols that appear in the format
pattern, spaces appear.
Placeholders are filled from right to left, unless you specify an exclamation point (!)
at the beginning of the format pattern. See Table 13-9 for examples.
& Same as @, except that if the string has fewer characters, spaces do not appear. See
Table13-9 for examples.
! Specifies that placeholders are to be filled from left to right. See Table 13 -9 for
examples.
> Converts string characters to uppercase.
< Converts string characters to lowercase.
Table13-9 Results of Custom String Format Patterns
Format pattern Data in the data source Results of formattin g
(@@@) @@@-@@@@ 6175551007
5551007
(617) 555-1007
( ) 555-1007
(&&&) &&&-&&&& 6175551007
5551007
(617) 555-1007
() 555-1007
!(@@@) @@@-@@@@ 6175551007
5551007
(617) 555-1007
(555) 100-7
!(&&&) &&&-&&&& 6175551007
5551007
(617) 555-1007
(555) 100-7
!(@@@) @@@-@@@@ + ext 9 5551007 (555) 100-7 + ext 9
!(&&&) &&&-&&&& + ext 9 5551007 (555) 100-7 + ext 9
>&&&-&&&&&-&& D1234567xy D12-34567-XY
<&&&-&&&&&-&& D1234567xy d12-34567-xy