Maximizing Your Org-to-Org Migration Process with DemandTools
Join us on February 6th at 11:00 AM EST for an in-depth training session on using DemandTools 5.x's Import module for Salesforce org-to-org migrations. Sr. Customer Success Manager An...
Malformed Data often sneaks into our CRMs undetected. In this session we will take a closer look at how to identify malformed data in your CRM and provide an overview of how to use DemandTools for remediation. Check below for some of the Record Sele...
Hi All,
It was great seeing everyone turn out for our first Identifying Malformed Data webinar! I was excited to show you how to align your search with your Assess module results, but more importantly, find all that dirty data!
Here is what I conditi...
Hi Everyone,It was a pleasure hosting the Modify: Using Advanced Formulas for Data Standardization webinar today. I hope you all found it useful!I'm going to include all formulas that I used as examples during the session. I will also provide the l...
Huge thanks to everyone who attended today's training on Using Formulas for Advanced Data Standardization. Below are a few additional resources that were referenced during the training. Also, I am going to add a comment with samples of the formulas ...
Hey @CRMSarah ,
I like this formula better by the way if you're going to be using a custom one:
IF(
${Suffix} <> "",
${Suffix},
IF(
RIGHT(LOWER(TRIM(RegExReplace(${Name}, "[^a-zA-Z ]", ""))), 3) = " jr",
"Jr.",
IF(
RIGHT(LOWER...
Hi Sarah,My pleasure! I just tested (ParseNameReturnSuffix(${Name})) and it returned nothing into the suffix field. Are you seeing something different?Best,
Hi @CRMSarah !
I tested CPA, PMP, ESQ and they all worked as expected with the formula. It doesn't capture all suffixes in all sectors, but has the most common. I'm going to see if I can get a list. I also was able to create a custom formula if yo...
Hi @HarveyDanger ,
If you have concerns about an email addresses status that was returned by BriteVerify, I would email Support as support@validity.com or use this link:https://knowledge.validity.com/s/contactsupport?language=en_USEither option will ...