Ella, You can do this with a little SQL, be counting the difference between
the string and the string sans spaces. It's not a perfect methodology, but
it should get you a pretty close ballpark. Here's an example from
TextEntries:

SELECT TextEntry,
(LEN(CONVERT(NVARCHAR(max),TextEntry))-LEN(REPLACE(CONVERT(NVARCHAR(max),TextEntry),'
',''))+1) FROM TextEntries

The NVARCHAR will be compliant with all versions of TMS. If you want the
curators to be able to search based upon this value in a given field, then
try caching it into one of the user defined field on ObjContext. You can
use a Job to periodically update those values.

~Chad

On Fri, Nov 30, 2012 at 10:50 AM, Ella Rothgangel
<[log in to unmask]>wrote:

>  Has anyone found a way to count the number of words in a field?  Either
> a large text field or text entries is fine.  I have curators interested in
> composing label copy in tms, but I need to have an answer to the word count
> hurdle.****
>
> ** **
>
> Thanks,****
>
> ** **
>
> Ella****
>
> ** **
>
> ** **
>
> ** **
>
> Ella Rothgangel****
>
> Collections Information & Imaging Administrator****
>
> Saint Louis Art Museum****
>
> One Fine Arts Drive, Forest Park****
>
> St. Louis, Missouri  63110****
>
> 314.655.5408****
>
> ** **
>  To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
>  You will receive a confirmation that your subscription has been removed.
>

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.