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.