split a text and store a word statistic in a relationship table
I'm new to filemaker and searching for a solution. I like to store a keyword statistic of a web-page and compare it to another one. The single words should be analzed according to their occurences and stored in a separate table called analyzed_words. From my point-of-view I need the following steps:
1. load the content of a web-page via url given in a text-field
2. cleanup the html content to get the pure text
3. split the text into the single words
4. count equal words and store the result in the analyzed_words related table
I managed to do steps 1-2. I'm now searching for a way to split the text into the words and store them in the related table. I think I need to trigger a skript via button-click and do the action there?
Maybe somebody has an aproach for me. Or is this kind of task not possible with filemaker?
Thanks in advance,