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.