SUBSTRING_REGEXPR

[Former Member]

Hi

The example given for SUBSTRING_REGEXPR does not work, any ideas?

     SELECT SUBSTR_REGEXPR('([[:digit:]]{4})([[:digit:]]{2})([[:digit:]]{2})' IN '20140401' GROUP 3) "substring_regexpr" FROM DUMMY

Could not execute 'SELECT SUBSTR_REGEXPR('([[:digit:]]{4})([[:digit:]]{2})([[:digit:]]{2})' IN '20140401' GROUP 3) ...' SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "IN": line 1 col 74 (at pos 74)

http://help.sap.com/saphelp_hanaplatform/helpdata/en/a2/f80e8ac8904c13959c69bfc3058f19/content.htm

I'm using version 1.00.81.00.392776 of HANA

Is this a new feature in SPS 09?

Thanks

Tobbi

[lbreddemann · Accepted solution]

Yep, this is new with SPS 9.

Before that, there were no REGEX functions in SAP HANA SQL.

- Lars