AnsweredAssumed Answered

performing calculations on textual data in FileMaker pro

Question asked by KristineGentry on Apr 15, 2011
Latest reply on Apr 18, 2011 by KristineGentry

Title

performing calculations on textual data in FileMaker pro

Post

I have several columns of text that I want to run some calculations on and I don't know how to get started.

I have 9 columns that have text in them.  I want to search the nine columns and get the frequency with which certain words appear.  The columns are populated with text from a values list, so I would like to see how many times each choice shows up across the 9 columns.  And, ideally get an average from that too.

I'm new to FileMaker and got the database set up and the data input, but I can't figure out how to get started using FMP to analyze any of it.  Any guidance would be greatly appreciated. 

Outcomes