Alpha Clean Account Names in Modify

[MNajmola2]

Hello,

I have a field where I house the AlphaClean version of the Account Name in SFDC so we can see if we have any quotes or clients across the globe under the same account hierarchy for cross-selling.  I use the AlphaClean in the dedup to update that field but I have accounts in our org that do not have a match to another account but I still update the Account Short Name.  

Is there a way in DT where I can pull the Account Name and see the AlphaClean name with all the prefix/suffix I've added in my tool removed so I can populate the clean account name field?  My research is indicating that I have to build a formula and basically add all the prefix/suffix to the formula manually.  I have so many suffix entered; what would take so much time.  Is there another way?

[Pugs_Validity]

Hey @MNajmola2 - If I am understanding correctly, you are referring to the Cleaned Account Name comparison type, not the Alpha Clean cleansing option? While we don't have a formula you can use to generate these names, it should not be terribly difficult if you are only using the Prefix & Suffixes that are out of the box in your Cleanse Rules. Are you looking for a more robust option or just the current comparison type in an actionable Modify formula?

Comparison Types

Cleanse Rules