0

If string include substring

Hi all,

can you please help me a little :) My background is in PHP programming and I am ready struggling with Klipfolio functions :/

I have a table and I want to check if the string includes substring. 

Example: 

Main string: "368 - Test my John Smit name"

I want to check if this string includes the word "John Smit".

Can you please help me what function should I use. I have already tried: INDEXOF, CONTAINS but for now no luck...

Thank you for your help

Best regards, Boštjan

1 comment

  • 0
    Avatar
    Meggan King

    Hello,

    CONTAINS will return a true or false: 

    INDEXOF returns a numeric value

     

    SUBSTRING with INDEXOF can parse your line

     

    However, in your case, I assume you have data and not a simple line, so I'm not clear on what you are trying to create here? You can always reach the support team at support @ klipfolio.com 

    Thanks!

     

Please sign in to leave a comment.