I use a formula in Notes (version 5) to display address information on documents in the following format:
2215 Sanders Road, 0581796
Northbrook, Il 60062
(800) 333-4444 Fax
The formula is:
@ProperCase(PHP_ADR_LN1) + ", " + @ProperCase(LOC_CD) +
@NewLine + @ProperCase(PHP_ADR_LN2) +
@NewLine + TEM_CBK_PHN_NB +
@NewLine + TEM_FAX_NB + " " + "Fax"
The PHP_ADR_LN2 component contains the City, State and Zip Code information. What I need to do is to display the state abbreviation in UPPER Case while leaving the rest of the information in PROPER case.
Assuming that I don't ask the data provider to modify their format, how should I approach this problem?
Thanks in advance for your help