.csv file to apl numeric matrix

yahoo and google financial web sites have historical stock data
bases
downloadable to excel and apple's new numbers spreadsheet.
we've used fn delta fv to convert .csv comma delimited file to apl
numeric matrix - r rows x hi, lo, close columns.          since
stock
prices can be 4, 5 or 6 digits including period (how about buffet's
hathaway 9 digit?) conversion involves varying column widths.
is
there any other way?      thanks.    don mattern

If the CSV file has no more than 65,536 rows AND the initial 25 rows
contain representative data then I'd do it this way:

1. use ADO & the Microsoft Jet 4.0 provider to read the source
2. fix the APL variable using the GetRows method of the ADO Recordset.

Don,

This is such a common requirement that APLX now includes system
functions to import data in CSV and other popular formats - take a
look at =E2=8E=95IMPORT and =E2=8E=95EXPORT in APLX version 4 ([url]http://www.mi=[/url
]
croapl.com/
apl/APLXLangRef.pdf).

Richard Nabavi
MicroAPL


On 16 Mar, 18:53, "d...@inetpurchasing.com" <d...@inetpurchasing.com>
wrote:
>     yahoo and google financial web sites have historical stock data
> bases
> downloadable to excel and apple's new numbers spreadsheet.
> we've used fn delta fv to convert .csv comma delimited file to apl
> numeric matrix - r rows x hi, lo, close columns.          since
> stock
> prices can be 4, 5 or 6 digits including period (how about buffet's
> hathaway 9 digit?) conversion involves varying column widths.
> is
> there any other way?      thanks.    don mattern