in my raw data, they're 5 line's

ex:
Q1.how old are you?
A1.under 20
A2.21-30
A3.31-40
A4.above 40

but the output in text object are all in the same line like
Q1.how old are you?A1.under 20A2.21-30A3.31-40A4.above 40

it's abuse to use '\n', what are other ways to separate them?

thanks~[IMG]smileys/smiley1.gif" align="middle" />

Edited by crystaliao - 28 Sep 2010 at 4:59pm

so glade to get your answer, Emir
but where should I set chr(13)?

Edited by crystaliao - 28 Sep 2010 at 1:02am

you mean put it in database?
like this...
Q1.how old are you? chr(13)A1.under 20 chr(13)A2.21-30 chr(13)A3.31-40 chr(13)A4.above 40

I've try chr(13),chr(10),\n,\r
but non of it can work.

did I use wrong way to put it on?

my environment is.....
asp.net 3.5 for C#
visual studio 2008
SQL server 2008





Edited by crystaliao - 28 Sep 2010 at 5:08pm