> 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)