Want to Stop Rebuilding "Expensive" Parts of your Flow? Explicit Builds are the Answer!READ MORE

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 Alumni

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

?
Labels (1)
A banner prompting to get Dataiku