Start a new topic

USPS Address Format

I'm very new to Omatic and was wondering if anyone knows how I can get rid of the "." in the address?  I do have a file I was given from my trainer to put the address in USPS format, but it doesn't get rid of the "." it does do the abbreviations.  For instance, if I have an address 405 W. 95th Street, it will abbreviate Street to St but it won't remove the "." after the W.  I have attached the file I was given.

 

Thank you in advance for your assistance!


You can do this with a dictionary.

Replacement value: -BLANK-
Value to match: \.
Make sure to turn RegEx on for this one.
Login or Signup to post a comment