Validity Customer Community

AnthonyValidity · 06-20-2024

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...

AnthonyValidity · 02-27-2024

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...

AnthonyValidity · 02-20-2024

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...

AnthonyValidity · 11-14-2023

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 ...

AnthonyValidity · 09-26-2023

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 ...

AnthonyValidity

Hi @Murphybp79 ,Thank you for reaching out. Love to see people using Modify's Formula action - one of my faves. The reason why you're geting a syntax error is because SEARCH returns an error if there are no matches. We do allow comparing a returne...

AnthonyValidity · 10-18-2024

I can't find my last post where I corrected it to do what you wanted as far as 2, 3, 4, and 5 or more. Looking at the data patterns, I would like to accomplish conditions and formulas for If 3 words: First-Last-Last....If 4 words: First-First-Last-La...

AnthonyValidity · 10-18-2024

It is my pleasure! I'm sure you're going to learn more really fast using Modify and real life examples. Don't forget, any formula name that is in all caps means it is a spreasheet formula that you can google how to use. The propercased ones are ou...

AnthonyValidity · 10-17-2024

@PeteIntradiem , While I wait, I did want to provide a possible solution that would probably reduce the amount of manual labor you would then have to do in the Tune module. The Tune module allows you to view and edit fields real time and I think you...

AnthonyValidity · 10-17-2024

Thanks, @PeteIntradiem . How would you like to handle three words in the string? How about if there's more than 4? This is very hard to predict of course. Thanks,

Validity Customer Community

Your statistics

User Activity

Follow up to Today's Webinar: Identifying Malformed Data

Identifying Malformed Data Training Session Resources

Follow up to "Modify: Using Advanced Formulas for Data Standardization" Webinar

Formula Examples: Using Formulas for Advanced Data Standardization

Formula Examples: Using Formulas for Advanced Data Standardization

Re: Update Picklist Field Using Formula with SEARCH function

Re: Modifying contact names with special characters

Re: Modifying contact names with special characters

Re: Modifying contact names with special characters

Re: Modifying contact names with special characters

Get your blog on