Jump to content

Word Frequency


This topic is 4352 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am in the process of trying to make filemaker read. I need a calculation to list the words according to frequency preferably from a field from all related records. I also need to exclude a custom list of common words, ie A, The, An, Etc. the output i need is as a carriage return value list in one field. I know i can script it but is it possible to calculate it?

Similar to the below but witht he ability to exclude words of up to a particular length and custom words.

http://www.writewords.org.uk/word_count.asp

Can this be done with filemaker or do i need to use java?

Link to comment
Share on other sites

I believe it can, but a custom function is limited to 50,000 recursions (provided it's tail-recursive, otherwise the limit is 10,000). Also, if the calculation is referencing related fields, it must be unstored - and as such will recalculate at every screen refresh. This may prove to be too annoying, as there is quite a lot of processing to do here.

OTOH, you can probably simulate "live" by using script triggers.

Link to comment
Share on other sites

This topic is 4352 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.