I’m interested in testing a string field in each record for
several things: the number of times that something occurs in the
string, the number of times that several different things occur in the
string together at the same time, etc., including the record in the
selection if a variety of criteria are achieved, otherwise not.
For example, if the letter “a” occurs at least 3 times, or maybe
if “a” and “b” don’t occur together more than 2 times in that field,
or if at least any 2 of the letters “a” or “b” or “c” can be found
then the record would be output.
It would seem that I would have to test the field of each record
multiple times to accomplish those.
I could use either the “meta_where” gem or regular SQL, but I
can’t think of how to do this with either. Any suggestions?
Thanks,
Barney
Barney wrote in post #1017017:
I’m interested in testing a string field in each record for
several things: the number of times that something occurs in the
string, the number of times that several different things occur in the
string together at the same time, etc., including the record in the
selection if a variety of criteria are achieved, otherwise not.
For example, if the letter “a” occurs at least 3 times,
=~ /a.*a.*a/
or maybe
if “a” and “b” don’t occur together more than 2 times in that field,
!~ /(ab.*){3,}/
or if at least any 2 of the letters “a” or “b” or “c” can be found
=~ /[abc].*[abc]/