processing multi line text

Hi!

I have a form application.It has a text item of size varchar2(2000).User cut and paste text in this box,which is a multi line text.When users click on save button my procedure should take this text string from form as a input variable and separate as each field per each line.My program not able to split as separate lines of this text.Is there any way to do this text processing in forms.I appreciate your help

thanks

Kris,

You should be able to write some Pl/SQL that loops through the text and looks for CHR(13) or CHR(10) (or maybe even both !!) and cut the lines that way.

Hope this is of help.