Find/Replace tick marks (quote marks)

[Ian Murphy]

Long-term novice (well, long-term intermediate user)here, with what I think is a fundamental question.

Over at the public library, reps from several departments keep events listings in a shared db. Once a month, I want to publish them to the web site. I've written some CSS tags that work neatly, so that (not actual field / CSS names, but you get it)

Event_name

Time_date

Registration

display correctly when popped into

Event_name

Time_date

Registration

What I want is for FileMaker to pop out that CSS, which I can paste into a page of HTML. (I know that I could have it pop out a bunch at one time, but I want these entries one at a time - both because they're getting pasted into Ajax collapsible panels, so need to be surrounded by other code, and because this is where I do light copy editing and want to inspect them as I paste them into the page.)

The headache I'm hitting is that the calculation won't deal with the tick marks ( " ) that the CSS code needs to see. That made sense to me, so I entered the code with bullets ( i.e.

and figured I'd add a Find/Replace script step to change the bullets to tick marks. But Find/Replace doesn't want to deal with the tick marks, since it thinks I'm inserting quoted text.

So the question boils down to this: what's the smart way for me to turn

Event_name

into

Event_name

?

[comment]

You could use a calculation =

"

" & Event_name & "

"

or simply:

"

" & Event_name & "

"

However, generating HTML code within Filemaker is hardly the smart way. You should export as XML and use a custom XSLT stylesheet to transform the result to the required HTML.

[Ian Murphy]

Sorry, I am using FMP 10 Advanced. I couldn't find that checkbox on my profile, so I selected it under "FM CLient" below this type entry screen - but probably didn't check this "Show FileMaker Profile" box.

[Ian Murphy]

Hm, still doesn't show up.

[comment]

The calculation will work in version 10, too - though you may write it more clearly as:

"

" & Event_name & "

"