Since there are a finite number of abbreviations you want to replace, I would write a set of rules that do the following:
Search for the EXACT string "po box" (not case sensitive) and replace it with "PO BOX" (all caps) Search for the EXACT string "p.o. box" (again, not case sensitive but this time there are periods in "p.o.") and replace it with "P.O. BOX" (all caps, with or without periods (your choice - I would probably leave them out. I don't think the post office likes periods in addresses)) " nw " becomes " NW " (MAKE SURE you include the spaces before after NW as part of the search criteria) And do the same for " N " (space 'n' space, otherwise EVERY lower case n will be replaced with a capital N ... you only want to replace the n with N where it stands by itself - for example: "1234 N Main Street") Same for " S ", " E ", " W ", " NE ", " SW ", and " SE " You'll have to write a regular expression and/or replace command to handle this -- Eric Carbone Systems Administrator MOR Printing, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 27, 2007 2:14 PM To: FusionPro Users Forum Subject: [fusionpro] Proper case Hello, I am using the rule for case selection, data file is all upper and I am changing to proper case. When I have a PO box it changes it to Po and NW becomes Nw. Can I fix that in FusionPro. Thanks in advance Laura +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Calling all FP Web Users! Do you have a question or lots of knowledge to share about FusionPro Web? If so, join our Printable Web to Print Users' Forum today! Send email to [EMAIL PROTECTED] to find out how! +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --