CSV ramblings

[Peter Bateman]

Hi All:

I like Ken idea of CSV being a supported record type.

The FORMATNUMBER function has made creating a CSV
in QTP a relatively easy process.

Because Quick has looping capability it is the product of choice
for CSV input files.
Use the INDEX function to find each field in turn.
Use MATCHPATTERN and other techniques to ensure the data is correct.

Because users can with Excel and others program
put any values in a CSV file  trying to load into a QUICK screen
with pre-defined fields is a nightmare.

Using  the UNIX pr command
you can create a file of so many columns  where each
column is of fixed width.  This file can then be edited
by QTP.  This is useful if you know that none of CSV column
widths can be greater than a certain size.

A utility which converts  a subfile to CSV or
a CSV to subfile would be useful
The .sfd or .psd could be the format determiner
or the data type and size as embedded in the header.

A little AI project would be to scan the CSV file
and determine the format. But, I think most of us would
be happy if we could dump to a subfile in the format which
we have declared.

There will be errors we need to report them.

Regards,
Peter

_________________________________________________________________
Share More On Messenger with a Windows Live Space 
http://spaces.live.com/?mkt=en-ca