Allow Replace transformation to apply to partial string replacement.
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.
-
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