07-11-2023 12:12 PM - edited 07-11-2023 12:16 PM
Huge thanks to everyone who attended today's training on Using Formulas for Advanced Data Standardization. Below is a link to the recording as well as a few additional resources that were referenced during the training. Also, I am going to add a comment with samples of the formulas that @JonG_Validity reviewed during the session. Feel free to drop questions below if you have them!
Session Recording
Modify Formula Dictionary
Wildcard Documentation/Examples
Solved! Go to Solution.
07-11-2023 12:14 PM - edited 07-11-2023 12:15 PM
Modify Formulas covered in today's session:
Adding US Country Code to Phone Numbers
Remove Special Characters from any field:
Fix 9 Digit US Zip Codes that do not have a hyphen:
Return US Zip Codes That are Malformed:
Return Canada Postal Codes that are Malformed:
Return UK Postal Codes that are Malformed:
12-29-2023 12:03 PM
Any formula in all caps should be easily found via google. They are spreadsheet formulas that you can find in other programs like Google Sheets and Excel.
Regards,
Get industry news, expert insights, strategies, and hot tips, served up fresh every week.
Visit the Validity blog