Hey Emma, Here's a custom function I wrote for this:
//Name: SentenceCase_CF //Parameters: textField Upper ( Left ( textField ; 1 ) ) & Lower ( Right ( textField ; Length ( textField ) - 1 ) ) -- Paul Spafford FileMaker Database Superhero, Spafford Data Solutions Tel: 613 838 9956 www.paulspafford.com www.ottawafilemakerdeveloper.com www.fmlayoutmode.com On Sep 29, 2010, at 8:49 AM, Emma Glaisher wrote: > 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 > > > 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.
