Scraping Keywords in Column for CRM Mentions in Job Descriptions

Joey W. · 2024-02-22T20:11:09.351709+00:00

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.

Clay T.

APP

·

Hi Joey W., happy to help!

Clay T.

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 T.

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?

Joey W.

·

Clay T.

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 T.

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! 🙂 🦸

9 comments