Skip to Content
0

Word Identified function

Feb 21 at 10:00 AM

22

avatar image

Hi,

is there any function to returning the word identified by its position like word_ext in BODS .

Ex: word_ext('www.bodi.com', 2, '.') returns 'bodi'. this is in bods ,Can any one suggest me similar function in SAP HANA SDI .

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jeff Kresse
Feb 21 at 04:01 PM
0

SDI uses the built in HANA functions. I would recommend reading through the various string functions here: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/20a24d4b75191014afc5ac3b997d3ce2.html

You will be able to accomplish this with RegEx functions. LOCATE_REGEXPR will find the first character that matches your expression, whereas SUBSTRING_REGEXPR will return the substring matching the expression itself. The latter seems to be more in line with your www.bodi.com example, so that's where I would start.

Share
10 |10000 characters needed characters left characters exceeded