performing calculations on textual data in FileMaker pro
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.