You cannot create a VIEW for this....
what i suggest is that you write a PL/SQL block that plays with the string and insert the values into a new table.
It is simple and easy.
Use INSTR(<Source string>, CHR(13) ) function to locate the enter keys in the field. CHR(13) is the enter key!!!