Skip to Content

Word Identified function

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 21 at 04:01 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded