Sqlloader question

How can i load in a varchar2 column, a text that contents returns of line?

For example the sqlloader file:

James#My car is red and
my house is big.#London
Jason#Hellow my friend!#San Francisco
Patrick#What a wonderful day!#Philadelphia

And the table is:

Name varchar2(20),
Comment varchar2(250),
City varchar2(20)



Thank you.

You might have a control file something like this

LOAD DATA
INFILE ''
INTO TABLE
FIELDS TERMINATED BY ’#’
OPTIONALLY ENCLOSED BY ’"’
(name, comment, city)

sqlloader reads line to line the text file and when it finds a return of line it rejects the record.

Thanks.