1 Reply Latest reply on Dec 25, 2008 12:40 PM by Jens Teich

    count the instance of one word in different fields

    missplumeau

      Title

      count the instance of one word in different fields

      Post

      I have a database of electrical panels (about 4000) for a large facility. each panel is one record with  a number of fields (panel name, location, building, floor, voltage....) including 42 individual fields that contain the description of each breaker in each panel. I need to keep count of the instance of certain values i.e. "spare", "blank" for each panel.

      I have tried playing with scripts to no avail so far...

       

        • 1. Re: count the instance of one word in different fields
          Jens Teich
             Create an extra table 'properties' with some records. Each one a single property. One record gets the entry 'blank' in the text field 'property'. in your original table there is one field which you can organize via valuelist in a way that it contains also the text 'blank' when appropriate.

          Now you can connect both fields and a calc fleld in the new table does all the counting:

          count(relationship::ID)


          Jens