Re: How to convert these tablespace output report into a delimited file, csv or tilde

2006-06-21 Thread John W. Krahn
BenBart wrote: > Hi all, Hello, > Can anyone suggest what is the best way to convert the lines of text > between the = into a delimited file? > > Do I have to read the lines one at a time and append the delimiter that > I wanted into the end of each line and then re-direct the output to

Re: How to convert these tablespace output report into a delimited file, csv or tilde

2006-06-21 Thread Muma W.
BenBart wrote: Hi all, Can anyone suggest what is the best way to convert the lines of text between the = into a delimited file? [...] I suggest setting the input-record-separator to "" since your tablespace records are separated by empty lines. Then you'd read in each record and u

Re: How to convert these tablespace output report into a delimited file, csv or tilde

2006-06-21 Thread John Ackley
There is more than one way to do it! #! /usr/bin/perl -w use strict; my $DELIMITER = "\t"; my $state = 0; while(<>) { if($state) { next if /Detailed explanation:|Normal/; if(/Number of containers.*= (.*)$/) { print "$DELIMITER$1\n";