...
The stringFormatter allows you to configure text field values to display/download as all upper-case or lower-case letters and what text displays/downloads for text fields with null values.
<stringFormatter caseConversion="lowercase" nullValue="[null]"/>
...
The phoneFormatter is used to format phone numbers.
<field len="15" name="mainphone">
<phoneFormatter pattern="(999) 999-9999"/>
</field>
Attribute Name | Description |
---|---|
len | Specifies the length of the output field |
pattern | See following table for sample patterns |
name | Name of the input field |
Here are some sample patterns:
Database Field Value | Pattern | Download Field Result |
---|---|---|
530-332-2233 | 9999999999 | 5303322233 |
530-332-2233 | 9999999 | 3322233 |
530-332-2233 | (999) 999-9999 | (530) 332-2233 |
5303322233 | (999) 999-9999 | (530) 332-2233 |
<numberFormatter>
The numberFormatter can be used for applying a variety of formats to numbers.
Example for applying a format for currency:
<field name="dep_other_income" len="20">
<numberFormatter format="%,d.00"/>
</field>
Attribute Name | Description |
---|---|
name | Name of the input field |
len | Specifies the length of the output field |
format | See the following table for sample formats |
Database Field Value | Format | Download Field Result |
---|---|---|
25000 | "$%,d.00" | $25,000.00 |
25000 | "%,d.00" | 25,000.00 |
Note: To view more format value examples, see: http://docs.oracle.com/javase/7/docs/api/java/util/ Formatter.html#syntax
...