Emma,

In that case, you should be able to combine both Melissa's and Paul's  
methods to get the job done - use Replace Field Contents with  
calculation, where calculation is Paul's custom function.

Lee.
=================
Binary Assist
220 Gaines Oak Way
Suwanee, GA 30024
Voice: (678) 313-5604
Internet: [log in to unmask]
Website: www.binaryassist.com

FileMaker Certified Developer







On Sep 29, 2010, at 10:11 AM, Emma Glaisher wrote:

> Sorry, I wasn’t clear. Each field contains completely different  
> text, in ‘proper’ or word case. I need to replace each field with  
> the same text, but in ‘sentence’ case, i.e. first character of each  
> line (after the bullet) is a cap, rest is lower case.
>
> In Quark or InDesign, I could select ‘sentence case’ but Filemaker  
> only allows Upper, Lower and Proper.
>
>
> On 29/9/10 15:06, "Blackburn, Melissa Chappars Ms." <[log in to unmask] 
> > wrote:
>
>>       Emma,
>>
>> I am thinking “Replace Field Contents” will work for you. Let me  
>> know if I am understanding you.
>>
>> Assuming you have two fields to change in the selected records:
>>
>> Do a find for only the records to be changed.
>> Type the corrected text in the field (the one you want to change) .
>> Leave your cursor in the field to be changed.
>> Then do a “Replace Field Contents” .
>>
>> Go to the second field to be changed.
>> Type the corrected text.
>> Leave your cursor in that field.
>> Then do a “Replace Field Contents” again .
>>
>> Regards, Melissa
>>
>>
>
>
> 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.