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.
.
• 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.