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

[Anthony J. Breeds-Taurima]

On Wed, 18 Dec 2002, Tim Bowden wrote:

> I have some data in the form:
> 
> a	b	c	d	e
> f	g	h	i	j
> k	l	m	n	o
> 
> and need it in the form:
> a	b
> 	c
> 	d
> 	e
> f	g
> 	h
> 	i
> 	j
> ...

---
#!/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!