Click here to get back home

FAQ 8.41 How do I use an SQL database?

 HomeNewsGroups | Search | About
 comp.lang.perl.misc    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
FAQ 8.41 How do I use an SQL database? PerlFAQ Server 03-15-2007
Posted by PerlFAQ Server on March 15, 2007, 4:03 am
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Similar ThreadsPosted
FAQ: How do I use an SQL database? October 21, 2004, 5:10 am
FAQ 8.41 How do I use an SQL database? March 17, 2005, 6:03 am
FAQ 8.41 How do I use an SQL database? May 30, 2005, 5:03 pm
FAQ 8.41 How do I use an SQL database? September 18, 2005, 4:03 am
FAQ 8.41 How do I use an SQL database? September 19, 2006, 9:03 am
FAQ 8.41 How do I use an SQL database? May 30, 2007, 3:03 am
FAQ 8.41 How do I use an SQL database? August 18, 2007, 3:03 am
FAQ 8.41 How do I use an SQL database? November 8, 2007, 9:03 pm
FAQ 8.41 How do I use an SQL database? January 23, 2008, 9:03 pm
XML to Database March 22, 2008, 4:52 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap