Emma, I think you might be able to use GetValue ( listOfValues ; valueNumber ) and the formula Paul gave you together to get the results you are looking for.
John On Sep 29, 2010, at 9:41 AM, Emma Glaisher wrote: > Nope. Proper capitalises every word. I want the first word of every sentence > capitalised. > > Bottle not included > > not: > Bottle Not Included > > I should add that the bullets (•) are part of the text, not inserted by my > email! > > So basically I need to capitalise the first word after each bullet. But there > may be any number of bulleted lines in the field. > > Emma > > > On 29/9/10 15:24, "Tom Tumbleson" <[email protected]> wrote: > >> Emma, >> Assuming that each description is in a single field; ie - field named "X" >> for instance >> . >> show all the records that you need to change - this operation will work on >> the selected set of records only >> place cursor inside field "X" >> under the "Records" menu item choose "Replace Field Contents" >> in the dialog box that appears choose "Specify" >> in the calculation dialog box type in Proper (X) ...... X being name of >> field where you want to make changes >> click OK >> click "Replace" >> . >> For your future reference, just like Upper (field name) makes all the text >> upper case and lower (field name) makes all the text lower case, >> Proper (field name) makes all the text proper case........ 1st word >> capitalized, etc. >> . >> >> >> >> From: Emma Glaisher <[email protected]> >> To: [email protected] >> Date: 09/29/2010 07:49 AM >> Subject: Sentence case >> >> >> >> I have several thousands records looking like: >> >> • Provides Chilled And Ambient Water >> • Bottle Not Included >> >> Which I need to change to: >> >> • Provides chilled and ambient water >> • Bottle not included >> >> I think I just have to start creating a complicated calculation, but if >> anyone knows a great tip, I’d be very grateful! >> >> Cheers >> Emma >> <http://service59.mimecast.com/mimecast/click?account=C29A8&code=2312e6fbca9fd63320a98c1b431986be> >> >> >> Emma Glaisher >> Artworker and Database Development - Fourninety Limited >> Tel: 0113 238 2447 >> http://www.fourninety.com/ <http://www.fourninety.com/> >> The Media Centre, Nepshaw Lane South, Morley, Leeds, West Yorkshire, LS27 7JQ >> >> Media Square plc or any of its subsidiary companies may not be held >> responsible for the content of this email as it may reflect the personal >> view of the sender and not that of the company. Should you receive this >> email in error, please notify the sender immediately and do not disclose, >> copy or distribute it. While Media Square plc scans all outbound emails for >> viruses, it cannot be held responsible for any infected files that you may >> receive. Media Square plc advises all recipients to virus scan any file >> attachments. >> >> Fourninety Limited, a member company of the Media Square plc group. >> Registered in England No. 3737606. Registered address 6 York Street, London, >> W1U 6PL >> >> This email message has been scanned and delivered safely by Mimecast >> <http://www.mimecast.co.uk/> . >> >> >> >> >> This email message has been scanned and delivered safely by Mimecast >> <http://www.mimecast.co.uk> . >> > > > > > Emma Glaisher > Artworker and Database Development - Fourninety Limited > Tel: 0113 238 2447 > http://www.fourninety.com/ > The Media Centre, Nepshaw Lane South, Morley, Leeds, West Yorkshire, LS27 7JQ > > Media Square plc or any of its subsidiary companies may not be held > responsible for the content of this email as it may reflect the personal view > of the sender and not that of the company. Should you receive this email in > error, please notify the sender immediately and do not disclose, copy or > distribute it. While Media Square plc scans all outbound emails for viruses, > it cannot be held responsible for any infected files that you may receive. > Media Square plc advises all recipients to virus scan any file attachments. > > Fourninety Limited, a member company of the Media Square plc group. > Registered in England No. 3737606. Registered address 6 York Street, London, > W1U 6PL > > This email message has been scanned and delivered safely by Mimecast. ________________________________________________ John Haley Information Technology Supervisor 713/681-1414 (Office) 832/969-0227 (Mobile) www.AlwaysInSeason.com
