Is there a way to import only the last line from ASCii data file?

This option could be expected in $SKIPLINES command, but I don't see it there.

The data file format is as follows (file name = ticker symbol):

Date,Open,High,Low,Close,Volume,OpenInt

11/09/09, 2.4500, 2.5100, 2.4500, 2.5000, 1137245, 652
11/10/09, 2.5500, 2.7300, 2.5500, 2.6300, 837775, 510
11/11/09, 2.75, 3.49, 2.73, 3.27, 6465800, 489
11/12/09, 3.19, 3.56, 3, 3.16, 4803500, 742

Format definition file to import all lines of data looks like this:

$FORMAT Date_MDY, Open, High, Low, Close, Volume, OpenInt
$SEPARATOR ,
$SKIPLINES 2
$AUTOADD 1
$CONT 1
$DEBUG 1
$BREAKONERR 1

How to import the last line only:

11/12/09, 3.19, 3.56, 3, 3.16, 4803500, 0


Reply via email to