Extracting First Name from Email Data: Seeking Team Assistance

Andrew L. · 2024-02-27 13:16:54.588225+00

Hi Team, I ran a boolean search and used that to extract emails but can't seem to figure out how to get the *First Name* extracted from the snippet or title. Any help would be appreciated!

Extracting First Name from Email Data: Seeking Team Assistance | Clay

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Andrew L.
·
·
https://app.clay.com/workspaces/225174/tables/t_uvAbsnwaQStj/views/gv_sXiDyrXe8nvf
Clay Team
APP
·
·
Hi Andrew L., taking a look!
Clay Team
APP
·
·
Which column are you hoping to extract the first name from?
Andrew L.
·
·
Thanks, out of the search result found column which contains the Title
Andrew L.
·
·
Hi Anjali, any ideas? Clay Team
Clay Team
APP
·
·
Hey Andrew, sorry for the delay. Perhaps Anjali had a few calls in between and wasn't able to circle back.I'll jump in here
Clay Team
APP
·
·
We can use the formula generator for this but since most of the Titles or Snippet sections aren't standardized, the code (which uses Javascript) won't be able to distinguish between a name or other words which is what AI may be best at in this case.
Clay Team
APP
·
·
If you want this to be much more consistent, I'd give those sections to chatGPT and ask it to create a separate list of just the name, title, and other information based on the inputs. I added an example to your table in case it helps. Let us know though
Andrew L.
·
·
Thanks Arturo, that makes sense. Not sure I see the example you added? I will try that in chatGPT though.
Clay Team
APP
·
·
Sorry, had to get the prompt so it took me a second. I'll add those credits back, once I can see it's a bit more consistent
Clay Team
APP
·
·
There you go, looks like it's working. Feel free to check the prompt and settings I added to the chatGPT column if it helps. Click on the header -> Edit Column to open that up.I just added the credits I used back in :)
Andrew L.
·
·
That is amazing, thanks! Very helpful to see how you did that. Is there also a way to just run it for say 100 rows instead of all 949?
Clay Team
APP
·
·
Yup!! Also in the column header -> Run Column :D... I have a video if it helpsHow to turn your table off, stop ongoing runs, also run a specific number of rows (bonus setting up row limits/filters) - https://www.loom.com/share/131e2c371a184748a87dc870304955b0
Clay Team
APP
·
·
And also one about JSON mode for chatGPT which is what I used here -> JSON mode in chatGPT: https://www.loom.com/share/317de47023fb429a80022de0f4a5d6dc

18 comments