Skip to Content

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

Does SAP HANA SQLScript Support Regex?

Hi,

           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?

Tags:
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