in reply to Converting carriage returns to HTML breaks

Are you certain they're carriage returns? That's \r, not \n.

You might need to post some example input and output otherwise.

Improve your skills with Modern Perl: the free book.

Replies are listed 'Best First'.
Re^2: Converting carriage returns to HTML breaks
by htmanning (Friar) on Apr 16, 2012 at 00:51 UTC
    Well, maybe I'm not certain. I hit the Return key in the email form. In all the other scripts I've used /n and it worked fine. I've tried /n and /r and neither work. I'm stumped. Here's what I'm doing. 
    Message field as it appears in database:

This is a test message.

This is line 2 of test message.



#This is how I'm getting it from the database...

$SQL="SELECT * FROM table WHERE name = '$name'";
&Do_SQL;
$pointer = $sth->fetchrow_hashref;
$message = $pointer->{'message'};
$message =~ s/\n/\<br\>/g;


Output:

This is a test message.  This is line 2 of test message.


If I View Source it shows:

This is a test message.

This is line 2 of test message.

    [download]
    I'm wondering if I have to do something special before it gets stuffed in the database, but I don't think so. I'm doing it the same way I always have.
[reply]
[d/l]

      I'm afraid that won't work

      Use Data::Dumper or Data::Dump to Dump data from your program as perl structures, and then show us that

[reply]

      I'm wondering if I have to do something special before it gets stuffed in the database, but I don't think so.

      As a general rule, you do not want to do something special before the database. You want to do something special before the email. When you need a particular encoding or alteration of your data for one use, you'll find yourself having to backtrack less often by doing that transformation as late and as local as possible.

[reply]

In Section Seekers of Perl Wisdom