Thanks. I was curious. :-)

--

rk

-----Original Message-----

From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com

Sent: Friday, April 21, 2017 4:38 PM

To: profoxtech@leafe.com

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

On 2017-04-21 11:24, Richard Kaye wrote:

> Only when it fits the situation. :-)

>

> Dirty? Really? One line of code returns the number of rows in your

> string. Which was your original question.

My solution was 1 line too: RowCount =

OCCURS(CHR(13),FILETOSTR(m.Filename)) <g>

>

> Benchmark it and you'll find out which one is faster and whether or

> not you can live with that slightly soiled sensations... ;-)

Testing showed these two pretty much a dead heat:

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

RowCount = ALINES(aCrap,FILETOSTR(m.Filename))

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/BN4PR10MB0913B5643363471841EB34ACD21A0@BN4PR10MB0913.namprd10.prod.outlook.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.