Derived field for Zip Code Formatting

[abowling]

I have a report that has zipcodes listed as follows:

75201
75201-1111
75201-1234
752011234
752011111

I need for all to be consistent(without dashes) as follows:

752010000
752011111
752011234
752011234
752011111

Any help would be greatly appreciated.

 

[CharlesCook]

Do a Derived field and use the Replace function.

THE SYNTAX WILL BE SPECIFIC TO YOU DATABASE BRAND:

For Oracle try this:
REPLACE(zipcodefieldname,'-','')



NOTE:zipcodefieldname needs to be the real database name.

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

 

[abowling]

Thank you, I was making it more difficult than it needed to be!