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.