Clay Icon
Join the Community
02 Support

Scraping Keywords in Column for CRM Mentions in Job Descriptions

Avatar of Joey W.Joey W.
·
·

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.

9 comments

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hi Joey W., happy to help!

  • Avatar of Clay T.
    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)
  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    this lets you indicate the keyword you're looking for as well as the cell in which it can be found

  • Avatar of Joey W.
    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?

  • Avatar of Joey W.
    Joey W.
    ·
    ·
  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Joey W., can you send me a link to this table?

  • Avatar of Clay T.
    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

  • Avatar of Joey W.
    Joey W.
    ·
    ·

    Ahh yes, that makes sense. Thanks for your help! 🙂 🦸