Converting Delimited Files

[Witkopp, Richard]

If it's a one-time thing, you can also just read it in
Excel and output it in fixed width fields.

For someone that can do macros you may even be able to
automate it somewhat.

> -----Original Message-----
> From: Karen Barrett [mailto:kbarrett@denkor.com]
> Sent: Friday, November 09, 2001 3:10 PM
> To: PowerhouseList
> Subject: RE: Converting Delimited Files
> 
> 
> 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
> 
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to 
> powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to 
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a 
> subscriber.
>