11 Replies Latest reply on Jan 11, 2010 8:17 AM by comment_1

    Find fields that repeat XX number of times

    Yoshihide

      Title

      Find fields that repeat XX number of times

      Post

      Hi, this is the first time here, and need help in finding a record.

       

      What I'm trying to do is to find a record that contains a certain text in the field more than XX number of times.

       

      For example, let's say that there is a record containing a "State" field like the one below.

       

      1  New York

      2  Washington

      3  Washington

      4  Florida

      5  California

      6  California

      7  California

      8  Florida

      9  Florida

       

      What I'd like to do, in this case, is to find a record that contains a "State" which exists more than 3 times.

      That would be California and Florida.  Records that contain New York, and Washington are not needed.

       

      So the search result would reveal records 4 ~ 9

       

       

      Is finding a record in such a way possible?

       

       

      Thanks,

      Yoshihide