0 votes
Hi,

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

Best,
by

1 Answer

+1 vote

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

by
Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!
1,328 questions
1,350 answers
1,550 comments
11,898 users

©Dataiku 2012-2018 - Privacy Policy