AnsweredAssumed Answered

Word Count in fields

Question asked by shaenh on Jul 7, 2015
Latest reply on Jul 7, 2015 by philmodjunk


Word Count in fields


I am trying to subtract words from a field. The problem is ever item in a field has a different amount of words. I have a word count field but it count all the words in a field. For example in my Product name field i have the below:

French Break-fronted Inlay Chest, Cherry  w. 42”, d. 21”, ht. 36 ½”

I want jus: French Break-fronted Inlay Chest

The problem is every item name has a different amount of words and filemaker counts everything besides the separators as words. Any suggestions would help