Scraping Keywords in Column for CRM Mentions in Job Descriptions

·

Does anyone know how to scrape info within a column for certain keywords? EG - I searched for specific open jobs, and then pulled matching job descriptions into a new column. Now I want to see if the job description mentions a specific CRM. Thanks in advance.

✅1

8 comments

Clay Team
APP
·
·
Hi Joey W., happy to help!
Clay Team
APP
·
·
if you navigate to enrich data and search up 'keywords' in the search panel, you should see na option to "Find Keywords"
7ec33008-ad90-48ba-a516-a53141d511e4.png(223 kB)
Clay Team
APP
·
·
this lets you indicate the keyword you're looking for as well as the cell in which it can be found
Joey W.
·
·
Thanks! I gave it a go and had some success, but often it's saying there's a missing input - even though the column it's supposed to be searching is populated. Any ideas where I could be messing up?
Clay Team
APP
·
·
Joey W., can you send me a link to this table?
Joey W.
·
·
https://app.clay.com/workspaces/223473/tables/t_YoWg0yQtnzSD/views/gv_hw0sBKKzNg8s
Clay Team
APP
·
·
Joey W. which description column would you like to check for keywords in? I see that there are a couple on your table and you might have accidentally pulled in the wrong one into the 'Find Keywords' enrichment. I reprinted the descriptions from the 'Find Active Job Openings' column and ran a keyword search on it (the last 2 columns on your table). I would check to make sure that you're referencing the correct target column in your enrichment panel
Joey W.
·
·
Ahh yes, that makes sense. Thanks for your help! 🙂 🦸