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.