[plug] Another OO.o spreadsheet problem- data manipulation

Tim Bowden bowden at iinet.net.au
Thu Dec 19 11:05:15 WST 2002


Thanks again Tony,

Problem solved in oo.o.  Unfortunantly using my win98 box @work & no 
time to download, setup & experiment with perl for this project. 
Solution (with typo corrections) looks very simple- perhaps it's time I 
took perl off the backburner.

Tim Bowden

> ---
> #!/usr/bin/perl
> 
> #include <http://thor.cantech.net.au/~tony/stddisclaimer.h>
> 
> wheil (<>) {
> 	@a = split(/\t/);     # replace "\t" with your delemiter
> 	print "$a[0]\t$a[1]";
> 	print join("\n\t", at a[2..$#a]),"\n";
> }
> ---
> 
> then run it as "perl script.pl <data.in >data.out
> then import data.out into OO
> 
> Yours Tony
> 
>    Jan 22-25 2003           Linux.Conf.AU            http://linux.conf.au/
> 		  The Australian Linux Technical Conference!
> 
> 
> 






More information about the plug mailing list