Click here to get back home

Serious Problem while appending an Excel file
 Home | NewsGroups | Search | About
Login Password
Register Now!
 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
Serious Problem while appending an Excel file thanawala27 07-24-2007
Posted by thanawala27 on July 24, 2007, 10:56 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

Posted by Paul Lalli on July 24, 2007, 11: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
adding an excel worksheet to a generetad excel file via perl April 17, 2007, 8:38 am
Appending to the middle of a file June 1, 2005, 11:29 am
better idiom for appending to list from file May 30, 2006, 3:22 pm
Re: opening file for appending doesn't work for me March 18, 2008, 5:09 pm
Re: opening file for appending doesn't work for me March 18, 2008, 9:45 pm
replacing text at the beginning of a file in perl and appending to that output July 20, 2005, 8:33 am
Win32::OLE Excel problem November 19, 2004, 11:56 am
Write Excel problem June 7, 2005, 10:14 pm
Problem with Name of Excel Chart September 22, 2005, 9:21 am
Problem using Spreadsheet::Excel October 31, 2006, 12:49 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap