Concatenating quote marks

[Geeksharka]

I'm sure this is pretty straight forward, but my brain has sadly lost its agility....

I need to create a calc field that concatenates various text elements, some static, some variable. Easy enough. The status elements are quoted into the concatenation, and the variable elements come from fields. For example:

"Please say hi to " & "NameFirst" & " " & NameLast & "for me."

My problem however is when any of the static elements have quote marks (") in them. This happens for example when I need to concatenate some Applescripts, or HTML, etc. etc.

For example:

do shell script "curl http://www.yourdomain.com/brochure01.pdf > ~/desktop/sample.pdf; open ~/desktop/sample.pdf"

Is a great little Applescript for grabbing stuff, but I'd like to make the doc that is curled from the URL a variable, by using a field in FMP. I usually would create a curl_filename field that is a calc like this:

"do shell script "curl http://www.yourdomain.com/" & curl_filename & " > ~/desktop/sample.pdf; open ~/desktop/sample.pdf""

but the problem now is the double quotes....

FMP utilizes the quote marks to delineate static bits within the calc -- is there any clever way round this?

Many thanks,

[Ugo DI LUCA]

Hi,

"I want to say" & ""Hello"" & "to Sharka" should do it.

4 quotes, 2 +2 ...

[Geeksharka]

Hi,

"I want to say" & ""Hello"" & "to Sharka" should do it.

4 quotes, 2 +2 ...

Unfortunately, no.

FMP sees:

"I want to say" &

""

hello

"" &

"to Sharka"

and it assumes 'hello' is a fieldname, and can't find it. (hence the error it gives you when you try this).

[Ugo DI LUCA]

Sorry, 3+3 is the answer

[Geeksharka]

Aha! Merci bien -- my brain was indeed not working.

[Ugo DI LUCA]

Coffee time there, isn't it?