Lesson 2.3 — Pull structured data out of free text

Transcript preview

This is the highest value job in the cleaning category. Taking something written as a paragraph and turning it into clean, separate columns. Here is what a client hands you. Enquiry messages, each one a paragraph, with the name, the company, the city and the contact buried somewhere inside. Ask for exactly the fields you want, separated by a pipe character. Name, company, city, phone or email. It reads the sentence the way a person would and pulls each one out. Then wrap that in the SPLIT function using the pipe as your delimiter, and every field becomes its own real column. Sortable, filterable, ready to import into their CRM. That is the file they actually asked for. Price this higher than plain cleaning, twenty thousand and up. Because the only alternative the client has is paying a person to read every single message by hand, and they know it.…