Custom Function Challenge ... Sentence Upper Case Cleaner

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

I could probably do this given enough time (which I really don’t have) and effort (and I’m not that willing). I thought I’d throw this out as a custom function challenge for those of you that like to show off your custom function skills!

It is the fourth quarter and that usually means that new and previously on hold client FileMaker projects start coming to developers from all possible directions. So I’m writing and updating a number of client proposals and sometimes I need to clean the input I get from clients. For example ...

It is quite common for a client to respond to my documentation with their text in bold red uppercase format. This is to help me see what their response was to my question or proposal. This is great but it makes it more difficult to copy / paste their input back into the master documentation. My master documentation resource is ... no surprise ... a FileMaker database! I was putting in some of my own little helpers but quickly began to wonder if there was something else out there.

So I cruised over to the custom function collection at briandunning.com. I love the site but the search capabilities there are a little raw. I ended up having to do a search for the term “text” and came up with 250 some odd results. I had about a hour before I had to clean up for an initial onsite client visit in Seattle. So I thought I’d review as many of these as I could and hopefully find something I could use.

Well, either I missed it or it isn’t there. What I would like to have is a custom function that looks at a paragraph or more of information that is in UPPER CASE ... and then ... return a result where all the characters in lower case with the exception of the first non space character after a period character. The end result being nice and clean sentences in which to update my master documentation.

SALES REPS WILL HAVE ACCESS ONLY TO INPUT LEADS AND TO ADD NOTES TO THE SUPPORT SECTION OF THEIR CLIENTS VIA THE WEB. REPS WILL BE ABLE TO VIEW ONLY THEIR CLIENT REPORTS.

will become

Sales reps will have access only to input leads and to add notes to the support section of their clients via the web. Reps will be able to view only their client reports.

So please feel to put your custom function in the comments or send it to me at info@dwaynewright.com and I’ll be sure to post all the results!

Thanks!
Dwayne
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.