> > I have a CSV file which I open with fopen()
> >
> > 2 things to ponder
> >
> > 1.
> > the csv file is permanently been written to by 3rd party
> >
> > I want to read the latest line of information -- in a loop
> > ok with loop, but get the last line I can't see how
> >
> > how do i do that?
> >
> > 2.
> >
> > I use FREAD() FSEEK(), but can't start at last line?
> > also lines are variable bytes length
> >
> > is FREAD() FSEEK() best way
> >
> >
> > Many Thanks if helping
> >
> > Phillipe
>
> You can use lowlevel as you do. Try using fgets() instead of fread() so you can loop line wise. There are alternatives which I prefer. If the text file is not very large:
> 1) FileToStr("myFile.csv") reads the file in a string variable and you could get the lines using alines() or memlines().
> 2) You could create a cursor and do an "append from type delimited" - or csv but delimited is preferable.
> Both operate very fast. If your csv file would invariably conain some data per line that you can differentiate (ie: in csv you get something like orderNo, productId whatever that may serve as a row identifier) then you could use a "for" clause with "append from" and directly get the line(s) you need.
>
> The best strategy depends on file content, size etc.
>
> Cetin Basoz
>
>
.Net has got better.Think about moving - check my blog:
>
Blog (main)>
Blog (mirror)Thanks for that
ok I will try fgets(), but how to get record pointer to last line is my problem
not sure how to do this
i can move to end of file, but not start of last line to read in (n) bytes for example
Phillipe