AnsweredAssumed Answered

count the instance of one word in different fields

Question asked by missplumeau on Dec 25, 2008
Latest reply on Dec 25, 2008 by Jens Teich

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...

 

Outcomes