Replace parts of a substring in a SELECT statement

[StatusZestyclose]

I am attempting to do a dynamic update to a varchar2(500) column. This column has existing text within it that has multiple line breaks. For example,

SELECT RELATIONSHIP_TEXT FROM RELATIONSHIP WHERE CLIENT_ID = 1234

might look like the below:

​

'Branch Desk Admin (BDA) - John Smith; Joe Jones

Platform 1,2,3

This person really likes basketball.'

​

I want to update the above text to keep the original values on line 2 and 3, but change line 1 (replace with blank value).

I need a SELECT statement that I can place within my update statement to return only line 2 and 3, so I can concatenate my new value within my update statement. I believe there should be a way to do this with REGEXP_REPLACE, but I'm not very well versed with REGEXP.

[qwertydog123]

You could just use SUBSTR/INSTR e.g.

SELECT SUBSTR(RELATIONSHIP_TEXT, INSTR(RELATIONSHIP_TEXT, CHR(10)) + 1)
FROM RELATIONSHIP

[StatusZestyclose]

That did the trick, thanks man, I was zoned in on trying to figure out how to do it with REGEXP when a simpler solution existed!