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.