× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. May 2010

RE: Find number of times a value occurs in a field

I have a field of 31 bytes that can have the value "O" or "W".
I *thought* there was either a BIF or Op-Code that I could use to find
the number of times a value occured, but can not find it in the manual.
ie: if the field contained WWWWWOOWWWWWOOWWWWWOOWWWWWOOWWW,
I would like to be able to get the value 23 for the number of times the
W occurred.

Well, I'm generally opposed to using SQL for non-SQL functions but this one
is ripe for the taking. :) Besides, if I don't suggest it then Birgitta or
Luis or Charles will. :)

Exec SQL Set :wCount = length(trim(:field)) -
length(trim(replace(:field,'W',''))) ;

I think that would do it. (Note lack of space between ending apostrophes on
that replace verb.)

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
Computers are not intelligent. They only think they are.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.