Hi Ella,

In a Crystal Report, you can use this formula:
UBound(Split({field}))

This actually counts the spaces between the words, so it will return the
word count minus 1.

Jeri

Jeri Moxley
Manager, Collection and Exhibition Technologies
The Museum of Modern Art
11 West 53 Street, New York, NY 10019-5497
Tel. (212) 708-9599 Fax. (212) 333-1102


On Fri, Nov 30, 2012 at 11:14 AM, Chad Petrovay <[log in to unmask]> wrote:

> 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.
>

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.