Converting Delimited Files

[Karen Barrett]

Hi John (and list) -

I was asking of the PH list. It was on the 3000L list that I found the other
proposals. I did that after I wrote a QTP that expanded comma-delimited
files using indexes and sub-record defines and it took FOREVER!! to run on
our 3000,  I finally had to kill the job.
This file came in originally as bytestream with imbedded (variable) field
and record delimiters and I now have it as tab-delimited, 27 fields where
the field sizes need to be expanded to 50 bytes each (1350 total) and the
tabs removed.
I'm a QTP fan but ran a sample using AWK on a comma-delimited version that
ran in 1 minute on the same machine that could not complete the QTP in 2
hours.  With AWK, I had to specify 27 field layouts and 27 parms. The Perl
solution was much more compact.

I just know that PH people are very resourceful! If there's an efficient
QTP, I'd like to try it. If not, AWK or..

Karen Barrett
Senior Program Analyst
Denkor Dental Management Corp.
(503) 644-6444 x4363
(503) 909-3404 pager