Numeric and date formats

There are three input format categories for the fields:

•	General. Data will be treated as a regular string of characters. This is the default format.

•	Numeric. Enables the StreamServer to handle input data as numeric data.

•	Date. Enables the StreamServer to handle input data as date formatted data.

Format tables

Numeric and date formats are made available through format tables. Before you specify numeric or date formats for the fields, you must add a format table to a resource set connected to the Message. You can import Formats.txt from

<StreamServe installation>\Applications\StreamServer\<version>\Tools\Samples 

to the resource set.

The first time you specify a numeric or date format for a field, a resource selection dialog box opens. In this dialog box, you must browse to, and select, the format table you want to use. This table will be selected by default the next time you specify a format for any of the fields in the Event configuration.

To select a numeric | date format for a field

1	Select the field. The field properties are displayed in the Properties view.

2	In the Input Format field, click Select. The Formats dialog box opens.

3	Select the Numeric | Date category.

4	Double-click the Format that corresponds to the input format.

Example 22

Numeric formats

Input 1000000,25 corresponds to k= d=,

Input 1000,000.25 corresponds to k=,d=.

 

Example 23

Date formats

Input 31/10/03 corresponds to dd/mm/yy

Input 2003-10-03 corresponds to yyyy-mm-dd

 

To add a new format

Enter the new format in the Format field and click Add.

You can also add new formats directly to the format table resource.