...
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
...