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 ...
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 ...
Hi @michael-wtds !I'm glad you were able to get this to work. Have you tried the Date Comparison type instead?Date: Allows dates with different formats to be matched and allows matching date to date/time fields (ignores the time). You can check out...
Hi @michael-wtds ,
You're using Modify to try to match records? Can you give me the full use case? Also, what information is contained in the Close Date field? Does it look like this on the backend, YYYY-MM-DD?Best,
Hi @DanielNeufeld ,This feature isn't currently in DupeBlocker but it is under consideration. If you follow the instructions within this article, you can find it and then vote on it.Best,
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...