Applying a string format

You can format string data to correct text that contains inconsistent capitalization, or to include characters, such as a space or a punctuation mark, at a specific place in the string. For example, you can display United States telephone numbers in one of the following formats:

(415) 555-2121

415.555.2121

415-555-2121

This section describes how you can select a standard string format, and how you can define a custom string format for data in a report.

How to apply a string format

1	Select a column that contains string data.

2	From the context menu, choose Format→Format Data.

3	On String column format, select one of the formats from the list. You can select a standard format or define a custom format. Standard and custom formats are described in the next sections.

Choose OK.

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2