Enable Short vs Long Formatting for Address Lines
Currently, the replace function will impact the entire string. Example: When formatting an address, 111 West 3rd Street, I want to replace West with W & Street with St. In this scenario, the current functionality will give me an output of “W”. I would like to request the functionality to replace individual elements of a string. Example: When formatting an address, 111 West 3rd Street, I’d like to replace both West with W and Street with St, giving me an output of 111 W 3rd St. Without this additional functionality it is impossible to keep aligned with our database standards using OC.
Ryan Powell
shared this idea
-
Jessica Daggett
commented
Fantastic, this will allow me to use Omatic Cloud for flat file imports once this is released! I don't know if it's possible to also have it add "Unit" or "#" or something in front of a lone number or letter at the end? For example people will type in "1451 24th Street 528" and would be great to end up with "1451 24th St #528". Not sure if that's possible. It would also be amazing for the transformation to work well with concatenate for a second line. For example, if people enter "4300 Cherry Creek Drive South" on one field and "Apartment B" on a second field, for the transformation/concat to allow us to import "4300 Cherry Creek Dr S Apt B" all into Address Line 1. Thank you for your consideration!
-
John Rivett
commented
We have many addresses that come in with directions, e.g., NW, NE, SE, etc.; after the case transformation they come in as Nw, Ne, Se, etc.Then there are case were PO and US that need to be all caps but come out as Po or Us.As it is, we will have to cleanup the file since this cannot be done within Omatic, but it would be a great feature to have.
-
Amy Wong
commented
Address clean up transformations like St. to Street, etc