Subject Re: Search in string
From Mervyn Bick <invalid@invalid.invalid>
Date Wed, 18 Apr 2018 13:01:17 +0200
Newsgroups dbase.getting-started

On 2018-04-18 11:00 AM, Patrick wrote:
> Sorry Ken, both commands don't work, I use dBase 5 for dbdos.
> May I send you a little fee via PayPal for another command, I really need this to work please.


The following works for me.

use whatever
count for 'something'$fieldname to nCount
?nCount
use


The search is case sensitive so you may want to use

count for 'something'$lower(fieldname) to nCount

This will give you the number of records containing the search string.
If you want to know how many times the is used in the field for a given
record, that's a different problem with a different solution. :-)

Mervyn.