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