Partial string 'Replace' transformation
It was a sad day when I realized that there wasn't a Transformation for address abbreviation standardization like there is in IOM (https://support.omaticsoftware.com/s/article/RegularExpressionDictionaryforAddressAbbreviations) and sadder still when I learned that I couldn't create a transformation of my own. While the 'Replace' transformation will IDENTIFY a field value containing a qualifying text string just fine, it will also replace the ENTIRE field value (not just the identified text string) with whatever replacement value you designate. Thought you could use a transformation for common address standardizations like replacing "Street" with "St"? Think again, because the way it exists now will replace "123 Main Street," "456 Elm St," and any other incoming field value with the word "Street" in it with just "St". But sadder even still is that this kind of standardization is absolutely critical because OC won't do fuzzy address matches (see https://omatic.uservoice.com/forums/950413-omatic-cloud/suggestions/46745101-allow-matching-on-fuzzy-address-formats). So, I'm forced to either create a bunch of duplicate records with OC (which my org paid a lot of money for) or fall back on IOM until RE Database View sunsets. Blargh.

-
Michelle Genberg commented
I wasn't told that OC couldn't do this. We only have OC do I will now have to do macros in the spreadsheet before importing it. I was trying to avoid this. One file we get has so many changes that have to be made that a transformation would be great.
-
Ryan Hinz commented
This would be a great addition!