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

ALINES()?

--

rk -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Friday, April 21, 2017 10:45 AM To: profoxtech@leafe.com 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