Strip Punctuation from Field 1

[sjp0362]

Is there a formula in Crystal Reports that can strip periods and commas out of a field?

I want to leave the punctuation within my data fields so that my other reports come out like I want them. Currently I'm trying to create a report that brings in all my address fields and follows the USPS guidelines (all caps with no periods or commas).

I know the formula for changing everything to all caps, but is there also a formula out there that can eliminate by periods and commas?

 

[dgillz]

Checkout this free UFL at Ken Hamady's site. About 2/3rds of the way down the page on the right.

http://www.kenhamady.com/bookmarks.html

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.srhconsulting.com

 

[bdreed35]

You can also do this without having to use a UFL:

Uppercase(replace(replace({table.field},".",""),",",""))

~Brian

 

[sjp0362]

Thanks for the suggestions. Since I've never used a UFL before, I decided to use the "replace" formula and it worked wonderfully.

Thanks again.