Re: Getting count of rows in a text file -- best approach?

Create a dummy database with one field append from text.txt  delimited go bottomnumberoflines = recno()

From: "mbsoftwaresolutions@mbsoftwaresolutions.com" mbsoftwaresolutions@mbsoftwaresolutions.com To: ProFox profox@leafe.com Sent: Friday, April 21, 2017 10:45 AM Subject: Getting count of rows in a text file -- best approach?

VF9SP2

Currently, I'm simply doing this for now:

RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename))

Is there a better (read: FASTER) way?  These are tab delimited text files so I can't really use FSEEK or FSIZE(m.Filename) (which requires SET COMPATIBLE ON) because I can't be sure of each record's length.

tia, --Mike

[excessive quoting removed by server]