At 15:57 +0200 4/12/07, Marek Stepanek wrote: >I am labouring a long while already with a Perl script, and I am helpless. I >already asked on perl.beginner > >http://groups.google.de/group/perl.beginners/browse_frm/thread/7b985c1ed1992ed9/527ea76679be3ad3?lnk=raot&hl=de#527ea76679be3ad3 > >but got no answer, probably because my question was not clear. > >I want to transform a Excel-Tabular into a LaTeX-Tabular and need to >calculate the sums for each double-line replacing the "TOTAL"-lines with the >calculated differences. > >The double lines (without the TOTAL-Line) have the form: > >15.03.2007 & 88701&50 & 38585&20 & 2184 & 64&50 & >199&10 & & & & Don \\ >16.03.2007 & 88868&80 & 38657&30 & 2195 & 64&50 & >328&20 & & & Name1 & Fre \\ >TOTAL & =SUMME(C3-C2) & =SUMME(D3-D2) & =SUMME(E3-E2) & >=SUMME(F3-F2) > >etc etc > >My actual script is calculating the differences only one time and replacing >the result to all following lines ... Why?
Yes. The question is not clear and the line wrapping doesn't help. But. . . The symptoms you describe are typical of an improper setting for the line end character(s) during the <IN> readline operation. It $/ is not set right it's possible to read the whole file looking for a lineend with the result looking like processing of only one line. $/ = "\r"; #Mac $/ = "\r\n"; #DOS or Internet $/ = "\n"; #UNIX the default $/ = ""; #Deliberately read the whole file. Sometimes undef $/; Open the file with BBEdit and see what BBEdit has to say about the line ends. So long as they are not mixed it's pretty reliable. -- Applescript syntax is like English spelling: Roughly, though not thoroughly, thought through. -- ------------------------------------------------------------------------ Have a feature request? Not sure the software's working correctly? If so, please send mail to <[EMAIL PROTECTED]>, not to the list. List FAQ: <http://www.barebones.com/support/lists/bbedit_script.shtml> List archives: <http://www.listsearch.com/bbeditscripting.lasso> To unsubscribe, send mail to: <[EMAIL PROTECTED]>
