Extracting a portion of a string in SQL

Question

I am facing challenges in extracting a portion of string in SQL:

Example being : I have to extract from the below string:

Can someone help me with a SQL formula to get this done?

Laurenz Albe · Answer 1 · 2020-06-29T15:52:33.153

1

(regexp_match(col, '^PAYPAL \*?([^ ]*) '))[1]

edited Jun 29 '20 at 15:52

answered Jun 29 '20 at 15:12

Laurenz Albe

I am guessing that the double quote is not in the string but just used as a delimiter for the question. – Gordon Linoff Jun 29 '20 at 15:32

1 Answers1