String Field Formatting

[2002 JI Open Discussion]

By: Tom Schneider - cs2

String Field Formatting

2003-05-04 12:56

I have a string field "123456789" that represents a Social Security Number. I tried using patterm="###-##-####" for format the field for the report. This does not work. Any ideas? I also need to format phone numbers.

 

 

 

 

By: Stephane Houle - stephoule

RE: String Field Formatting

2003-05-05 12:24

You can do some Java code in your textFieldExpression tag... Something like this:

<textFieldExpression>

ssn.substring( 0, 3 ) + "-" + ssn.substring( 3, 5 ) + "-" + ssn.substring( 5, 9 )

</textFieldExpression>