Saving linebreaks in a TEXT field

So I have my database and I read text from a webpage then put it in a record
including a field that is dataype TEXT.

Of course I lose line breaks, so what happens is that the following
sentence:

This is line 1...

.... and this is line 2

becomes "This is line 1... ... and this is line2"

Is there some function I can call in Perl or something else I can do so I
store and keep the format of the text?

Many thanks....

Daniel Kaplan wrote:
> So I have my database and I read text from a webpage then put it in a record
> including a field that is dataype TEXT.
>
> Of course I lose line breaks, so what happens is that the following
> sentence:
>
> This is line 1...
>
> ... and this is line 2
>
> becomes "This is line 1... ... and this is line2"
>
> Is there some function I can call in Perl or something else I can do so I
> store and keep the format of the text?
>
> Many thanks....
>
>
>

Look at the source for your web page. I suspect your line breaks are
there, and your problem is that HTML ignores them.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:vcudnX6Mb7d1lr3anZ2dnUVZ_qHinZ2d@comcast.com. ..


> Look at the source for your web page. I suspect your line breaks are
> there, and your problem is that HTML ignores them.


you make a good point, but then it comes to me finding them before i put
them in the DB, then converting them to <P> and <BR>, no?

off the top of your head, do you know what they are in the edit field when i
read it? \n? \r?

thanks

On 25 Oct, 04:47, "Daniel Kaplan" <NoS...@NoSpam.com> wrote:
> "Jerry Stuckle" <jstuck...@attglobal.net> wrote in message
>
> news:vcudnX6Mb7d1lr3anZ2dnUVZ_qHinZ2d@comcast.com. ..
>
> > Look at the source for your web page. I suspect your line breaks are
> > there, and your problem is that HTML ignores them.
>
> you make a good point, but then it comes to me finding them before i put
> them in the DB, then converting them to <P> and <BR>, no?
>
> off the top of your head, do you know what they are in the edit field when i
> read it? \n? \r?
>
> thanks

Depends, how are you "read[ing your] text from a webpage"?

Daniel Kaplan wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:vcudnX6Mb7d1lr3anZ2dnUVZ_qHinZ2d@comcast.com. ..
>
>
>> Look at the source for your web page. I suspect your line breaks are
>> there, and your problem is that HTML ignores them.
>
>
> you make a good point, but then it comes to me finding them before i put
> them in the DB, then converting them to <P> and <BR>, no?
>
> off the top of your head, do you know what they are in the edit field when i
> read it? \n? \r?
>
> thanks
>
>
>

Nope, you shouldn't be storing html commands in hour database. What if,
for instance, you decide you need to access it from a non-web based
environment, i.e. a command-line utility to generate some reports?

The formatting should be done after you retrieve the data form the
database, not before.

For the rest, try a programming group for the language you're using.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================