Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Concatenating quote marks

Geeksharka
in Calculation Engine (Define Fields)

Featured Replies

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,

Hi,

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

4 quotes, 2 +2 ...

  • Author

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).

  • Author

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

Create an account or sign in to comment

https://fmforums.com/topic/15633-concatenating-quote-marks/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.