how do I check for Double quote, single quote, tab etc

[bdenson]

I am trying to check for various chars such as double quote, single quote, tab, comma etc. I have tried using

count for field1 $ "\x23" to DoubleQuoteCount

and

count for field1 $ "\t" to TabCount

and so on but I dont get the results I expect.

Am I doing something wrong, or sould I recheck my expected results?

Thanks

barry

 

[jimstarr]

Hi Barry,

Try something like:

COUNT FOR CHR(34) $ field1 TO DoubleQuoteCount
or
COUNT FOR '"' $ field1 TO DoubleQuoteCount

and similarly for the other characters.

Jim

 

[weedz]

Hi Barry,

Try using the OCCURS(cSearchExpression, cExpressionSearched)function.
This one returns the number of times a character appears in a string.

HTH,
Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

Download the CrownBase source code !!

 

[bdenson]

Thanks Weedz, but I want to know the number of matching fields, not characters.

Barry

 

[weedz]

Sorry misunderstood.

In that case I'll choose for Jim's option ;-)

Cheers,

Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

Download the CrownBase source code !!