Skip to content
Gallery
AI + Operations
Start Here
Dirty Data
Metrics Library
Global Stakeholders
Takeaways
More
Share
Explore

icon picker
Dirty Data

info

Dirty Data

A major part of operations is data hygiene. The amount of time all operators have spent cleaning data is probably unthinkable.
Coda AI changes the game in the amount of time you use

Case Study

For a client I needed to clean mass quantities of contact data:
Names: With all different formats (middle names, titles, etc)
Phone #: Global numbers without proper formatting
Call #: They also wanted to call the contact by pressing a button

AI Execution

To accomplish this, Coda AI column saved the day and time:
1. Put dirty data into a table (yuck!)
2. Add column and use Coda AI Column to clean Name Data
clean up @Names (Raw) to be a first and a last name in a consistent format
3. Use Coda AI Column to format phone number
remove all spaces from @Phone (Raw) with a “tel: +” at the front and make a number
4. Add Button Column that opens to hyperlink of formatted phone #
5. Sky is the limit here! If you’ve got dirty data, give Coda AI Column a try

Contact List
Names (Raw)
Name (Clean)
Phone (Raw)
Phone (Clean)
Call Phone
1
OvaWest
Ova West
(688 211-9041
tel:+6882119041
Call
2
Alize west
Alize West
(413) 6302815
tel:+4136302815
Call
3
Duane Franecki II
Duane Franecki
929-400-5674
tel:+9294005674
Call
4
DorothyRice
Dorothy Rice
(638388-8064
tel:+6383888064
Call
5
Jayce Croooks
Jayce Crooks
751 5657745
tel:+7515657745
Call
6
earline Marquardt
Earline Marquardt
(268) 444-1209
tel:+2684441209
Call
7
Alexe Roob
Alexe Roob
(554) 644-9387
tel:+5546449387
Call
8
Mr. Reyna Zieme
Reyna Zieme
(282) 912-2108
tel:+2829122108
Call
9
Ms. Ariel Leannon
Ariel Leannon
(799) 201-9390
tel:+7992019390
Call
10
Orlo T. Mohr
Orlo Mohr
(268) 793-0742
tel:+2687930742
Call
11
Sarah O'Reilly-Smith
Sarah Smith
44 1632 960692
tel:+441632960692
Call
12
Ahmad denesik
Ahmad Denesik
+441632 960125
tel:+441632960125
Call
13
Blanca Sporer
Blanca Sporer
+44 1632960509
tel:+441632960509
Call
14
Alejandrin hessel
Alejandrin Hessel
441632960969
tel:+441632960969
Call
15
DorrisWilliamson
Dorris Williamson
441632 960878
tel:+441632960878
Call
There are no rows in this table
⁠



Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.