Clay Icon
Join the Community
02 Support

Controlling for PE as a Keyword: Case Sensitivity, Quotation Marks?

Avatar of Ian M.Ian M.
·
·

I thought I was making good progress with the Keyword approach (vs Score Row), until I hit this One of the "keywords", I am looking for is Private Equity, this works well/if fine. Private Equity is often abbreviated to PE by companies in their LinkedIn descriptions. So I added PE as a keyword And then saw this "huge unexpected result" .... I was flummoxed. The description is written in Bahasa (used in Indonesia and Malaysia) and in Bahasa, there are many words which have the 2 letters pe in them I can think of 2 ways to control for this a) Make it case sensitive as the PE I want is always always expressed in upper case b) Make it look for PE with space before and after (eg do I quote it as " PE " ) Will this work - any other ways?

8 comments

  • Avatar of Clay Team
    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 😉

  • Avatar of Ian M.
    Ian M.
    ·
    ·

    I have tried everything I can think of, tried to use single quotes, double quotes, spaces etc ... and nothing works as a work around. Sadly I HAVE to be able to look for PE as this a standard industry "term" I am hoping your engineering team can figure out a quick fix (fingers crossed)

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Ian, sorry for the delay! I'll take a look. Maybe for this one, we can use a formula instead to parse it exactly as you say, with upper case and/or with spaces. It should be able to return a count too

  • Avatar of Ian M.
    Ian M.
    ·
    ·

    Sounds like a feasible workaround.- can you show me how please

  • Avatar of Ian M.
    Ian M.
    ·
    ·

    Arturo O. - really hoping we can make this work as it would be a bit of a show stopper for me for this project

  • Avatar of Ian M.
    Ian M.
    ·
    ·

    Also can we figure out my best way to get some credits too please

  • Avatar of Ian M.
    Ian M.
    ·
    ·

    Arturo O. thank you thank you thank you ... I see the new col in my sheet with your formula - seems to work well! 🙏

    ✨1