Need help making a formula to pull out a certain text from a web scrap...

https://app.clay.com/workspaces/58610/tables/t_e7uZjkBDkeUd/views/gv_vUS6bY0vqut3

I want to extract the state from either the title or the body from the webscrape.

Got it to work for HomeAdvisor site but not yelp or bbb as you can see and sometimes it's pulling llc, inc. and other things instead of state

Gotcha, just checking out the column now. Can you give me an example row where it’s not working?

2979 you can see it didn't work, as well as 3586

gotcha, testing some things out

Thanks for the help!

hmm ok sorry still checking this out

the hard part of this is extracting the two letter state code from the body text with just a formula

You’ll probably need to use our Use AI (With ChatGPT) integration for that

It will be a bit too complex with formulas likely given the text won’t be standardized at all

gotcha, thanks for the help