SQL & PL/SQL

Hi,

I have an issue where I wish to trim space on a field and also remove new line character if any fields have new line character.

I understand to use TRIM('field ') to trim it. However if I want to check if there is a newline character and remove it how do i do that?

For instance say the column 'BLAH' on table 'TABLE1' is as such:

--new line character after text 'Blah'...
'Blah
'

How do I make this column so it is just value 'Blah'?

I thought to use:

regexp_instr but cannot work this out.