If I'm not mistaken what you're trying to achieve can be done by using this function:
indexOf(string s, string sub) --> number
Returns the index of the first ocurrence of sub in s. Returns -1 if there is no such occurrence.
See the reference here:
https://doc.dataiku.com/dss/latest/advanced/formula.html#indexof-string-s-string-sub-number
