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" <[log in to unmask]> 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 <[log in to unmask]>
> To: [log in to unmask]
> 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=2312e6fbc
> a9fd63320a98c1b431986be>
>
> 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> .
>
>
<BR>
@|from|cn|@
@|from|title|@ - @|from|company|@
Tel: @|from|telephonenumber|@
@|from|wwwhomepage|@
@|from|streetaddress|@, @|from|l|@, @|from|st|@, @|from|postalcode|@, @|from|co|@
-----------------------------------------------------------------------------------------------------------------------------------------
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 Office: Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ
This email message has been scanned and delivered safely by Mimecast.
-----------------------------------------------------------------------------------------------------------------------------------------
|
