Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

For readability...

by tedv (Pilgrim)
on Jan 15, 2001 at 23:11 UTC ( #52007=note: print w/replies, xml ) Need Help??

in reply to substitute an enter with regular expressions

Since you're putting real newline tags in, it's quite possible that other people might look at these entries. With that in mind, your substitute should keep things readable. Suppose my input looks like this:
Foo Bar Foobar

Then the actual string is "Foo\nBar\nFoobar\n". If I just ran a simple s/\n/<br>/g on the string, I'd get this output:

Clearly this would get illegible after 20 or so entries. So use a subtitute like this instead: s/\n/<br>\n/g
Your output should look like this:
Foo<BR> Bar<BR> Foobar<BR>


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://52007]
[marinersk]: Corion This DBA wants to smack others who like putting whitespace in column names.
[marinersk]: s/smack/whap/;
[talexb]: Wow, what hilariously bad form.
[SuicideJunkie]: Just wait; someday soon, you'll be given a DB with unicode emojis in the column names.
[Corion]: marinersk: Well, I have done select statements like select sum(foo) as "Total Amount", ..., but to have a table like that makes me shudder
[Corion]: SuicideJunkie: :-D
[marinersk]: SuicideJunkie LOL
[choroba]: Woohoo! Fixed a test that hasn't run for 3 years.
[marinersk]: Corion Yes, sometimes whitespace in column headers is acceptable, but I still consider it be less than desireable if that query might get revectored for an ETL-esque process...
[marinersk]: choroba++

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (14)
As of 2017-05-25 15:00 GMT
Find Nodes?
    Voting Booth?