The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I haven’t been able to find an answer to this on the site, but there doesn’t seem to be a function to count the number of words in a text field. There’s a function to count the number of characters – LEN.One workaround could be to the count the numbe...
I’m in the process of deciding whether to switch over from Filemaker, and my workflow involves a lot of text. Research notes, interview transcripts, article drafts. Filemaker allows me to have a text entry field the size of most of the screen.
I gues...
I realized that I could nest SUBSTITUTE functions to solve the double-spacing between paragraphs problem:
LEN(SUBSTITUTE(SUBSTITUTE(Text,"\n\n","\n"),"\n",""))
Thanks – great advice!
I took out all the space characters, then subtracted the length of the new string form the old string, to get the number of spaces in the text.
LEN(Text)-LEN(SUBSTITUTE(Text," “,”"))
The result were a slight undercount, but wit...
OK, in case anyone else is searching for this – my workaround is to divide the length of a text by 5.5: LEN(text_field)/5.5. (The average word length in English is 4.5 characters, plus another character for the space between words.)
It gets somewhat...
Add my name to the list of people who would REALLY want to have a rich text editor.
My preference? The WordPress approach of being able to switch between “visual” and “text” views.
I second this request. I would love, love, LOVE to be able to print out invoices. I currently either use Filemaker for this, or Google Spreadsheets, and this would enable me to move both of those work flows over.