Longtime Demand Tools user

[bhare1357]

Hi all - as I mentioned in the subject - have used Demand Tools a number of times over a number of different jobs over the years. I love Demand Tools because of it is power. At one career stop I was able to take all of the states in Salesforce and turn them into two letter abbreviations thorughout my company's Salesforce org - very cool and very helpful!!

If I can help out I will do my best to jump in and try to contribute some answers!

Bill

[SummerinGreece]

@bhare1357 we did the exact opposite 🙂
switched from state abbreviations to full names to accomodate Europe as well

[bhare1357]

@SummerinGreece - Interesting! 😀

[Beth_bohl]

Any idea why this formula isn't working?  StateMatchShortName({mailingstate}, UseFuzzy)   The error message is that there's an unknown variable UseFuzzy at position 45.

[Pugs_Validity]

@Beth_bohl - You'll need to instruct the formula whether you want to use the Fuzzy criteria or not. So the choice would be beteween StateMatchShortName(${mailingstate}, FALSE) or StateMatchShortName(${mailingstate}, TRUE)  

[Beth_bohl]

Thanks so much for responding!  I am just now returning to this after a busy month.  I initially rec'd an error on the $ sign, so I removed that.  I am next getting an error stating there's an unknown value FALSE at position 42 with StateMatchShortName({mailingstate}, FALSE) .  I get the same error if I use TRUE.  If I use the out of the box formula StateMatchShortName({mailingstate}, UseFuzzy), I get the same error on UseFuzzy. 

[AnthonyValidity]

Hi @bhare1357 (Bill),

I'm happy to see you've joined our community since you have years of experience!  I love it for the same reasons and mentioned in another post of mine about how Modify can really get the job done with existing data.  In DemandTools V (DTV) we now have over 127 formulas to use - one of them being the state standardization formula!  

StateMatchShortName(state, useFuzzy)

StateMatchLongName(state, useFuzzy)

The above are the two preinstalled formulas we have with DemandTools V (DTV) which can use fuzzy match to find misspelled states as well.

Again, so happy you're here!

Regards,
Anthony

[Beth_bohl]

When I use the preinstalled formulas and use the insert field function to add the field i get this:  StateMatchShortName({mailingstate}, UseFuzzy)   But I'm getting an error message that there's an unknown variable UseFuzzy at position 45.  

BTW, I absolutely love DemandTools.  It saves me hours of time to keep our data squeeky clean!  

[Pugs_Validity]

@Beth_bohl - You need to give a response for the UseFuzzy portion. So you'd need to use either StateMatchShortName({mailingstate}, TRUE)  or you can remove it all together, StateMatchShortName(${mailingstate}), or just change it to FALSE if you don't want to use Fuzzy Matching, StateMatchShortName(${mailingstate}, FALSE).

[LFoster]

I agree!  I am excited to share with new users and watch them realize the potential uses of the tool.  DT saved a small team a month long project of adjusting the case of account names.  It was done in 15 min.  They were so excited!