New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

CHARINDEX equivalent in DSS Formula

Philippe
Level 1
CHARINDEX equivalent in DSS Formula
Hi,

I am looking for the equivalent of CHARINDEX (ORACLE) in DSS Formula.

Best,
0 Kudos
1 Reply
cperdigou
Dataiker
Dataiker

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

Labels (1)
A banner prompting to get Dataiku DSS