Daniel T.

I have this exact problem in Filemaker 11 on Mac. I'm wondering if anyone can recommend a solution? I have a suspicion it has to do with sliding elements on the (somewhat complex) layout. When I do File > Save/Send Records As... > PDF, I get the weird margins (whole layout shifts over about an inch to the right), but if I do File > Print... and then Save to PDF using OS X's built-in print to PDF function, then the result looks as expected.

Hi SavvyData, I'm trying to accomplish the same thing (only label a few of the dates along the x-axis), would you mind elaborating a little on your advice to use a calendar data series? I'm not quite sure how to go about doing that. I have a set of records with a date field (field type Date) and those records have one of three checkboxes selected (boolean fields, either empty or "1".) I want a line chart with one line per checkbox, showing how many records of that type were present for that day. Dates along the x-axis, but with a nicely spaced scale that only shows a label say every 7 days, so it's actually readable. Do I need to create some calculation fields and then chart those calculations? If so what might that calculation look like? Thanks for the help!

Hey Søren, thanks for the clarification, I missed some of the links you attached the first time. I was looking at the highlighting custom function you linked to on briandunning.com, but now that I'm looking at Shawn's regular expression custom functions that looks very helpful as well. Thanks for the example you attached with the word "bird" highlighted. I pasted in a news article and searched for the " character, which did indeed highlight all the quotation marks in the text. Can you offer advice on how to highlight the text between the quotation marks as well as the marks themselves? That's the part I'm stuck on. I am certainly not an experienced programmer but from the little I do know the way to express what I'm looking for in the text is the regular expression ".*" but I'm not sure how to achieve that in FileMaker. It looks like I could use Shawn's custom functions to allow the use of regular expressions in combination with Brian's/your highlighting function? Thanks for the help! Daniel

Søren, thanks, this looks like a very promising direction. Since I'm looking for any text between quotation marks, for example, how would I format that request using this custom function?

I'm building a database of news articles for a research project. I have a text field called FullText into which I'll paste the text of each article. What I'm trying to do is to programmatically find all quotes in the article and highlight them with a particular color. That way I can quickly scan the article to see who's being quoted. The simplest way to define a 'quote' is any text in between quotation marks (straight quotes or curly quotes, single or double.) A more complicated kind of quote could be looking for the word "said" and highlighting the entire sentence, in the case where the author is summarizing information she got from an outside source. Since I don't think FileMaker lets you use regular expressions in a script, I'm at a loss how to do this. Any advice is greatly appreciated! Thanks, Daniel

Thanks for the solution, although I had to modify the code a little to get it to work: Substitute( List( relation::field ); "¶"; ", ")