Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Does SAP HANA SQLScript Support Regex?


           I have to write a procedure which takes string as an input and checks whether the corresponding string has any special characters or not

after browsing through the HANA docs, I could find out a method LOCATE, which searches for given character

Is there a easy way to do this for example using the REGEX to find out the special characters?

Former Member
Former Member replied

are you looking something like this:

select SUBSTR_REGEXPR ('is' in 'This is a Test') from dummy;

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question