SAP HANA SQLScript · Strings & Regular Expressions

How do you extract just the host part of an email that a regex matched? ``` SUBSTR_REGEXPR( '(user)@(host)' FLAG 'i' IN line GROUP 2) ```

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in Strings & Regular Expressions

What's wrong with putting FORMAT('{0}', val) in a SELECT field list?

Why can't you write TABLE_SUMMARY((SELECT * FROM tasks))?

What is A3 after this? ``` (A1,A2,A3) = STRING_LIB:SPLIT( 'ABC-DEF-GHI-JKL', '-', 2); ```

You declare a column as col NVARCHAR with no length. What length does it get?

What does a negative <start> do in LOCATE(str, search, start)?

What does LPAD('ABC',8,'begin') return?

Start learning today

Free to start — download the app or use it in your browser.