Character or Word Count on an RTF Field

[USInc]

A table in our database used to be stored as plain text, however it just got converted over to RTF. Before this I was using len({MyField}) to get a character count. Now this formula doesn't work thanks to the RTF formatting.

So I started using UBound(Split({MyField})) which was great until I realized that some of the data contained more than 1000 words.

So, can anyone help me come up with a way of counting either characters or words (or both)?

Thanks very much!

 

[fisheromacse]

I am thinking that the best solution may be to modify my suggestions above by replacing "fs20" with "fs"
this will leave the numbers, but should remove the majority of the rtf formatting commands.

you could use 'len({@RTF4})' to get the # of characters remaining.
or
you could use 'Count(Split({@RTF4},' '))' to find the # of spaces.