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.

how to use quotes ("") in calculations

Featured Replies

Hi, I'm trying to merge some text fields using a calculation. I can enter text surrounded by quotes, like this: "some text" & " " & "more text". But how do I quote quotes within quotes? laugh.gif" border="0 Like this: "some text" & """ & "more text". Obviously that doens't work... Using the word 'quote' doens't help either. Can someone give me a clue? I'm amazed FM is not able to quote quotes. crazy.gif" border="0 I couldn't find anything in the manual nor the filemaker techinfo database, which seems to be down once again. I would like to prevent using seperate fields for just the 'quote' character. If I would do that the result would be this: "some text" & quote & "more text". Doesn't sound that bad, yet there has to be an easier way, right?

--

Dodge

You need to use an extra set of quotes. Search this forum because the question has been answered several times.

  • Author
mad.gif" border="0

H

what i do.. is i make a global field and name it quote... then i put a quote in that field, then i delete that field off of any layout so it isnt seen by anyone.. it should still keep the quote in it.. then anytime i need to have a quote in teh calculation field, i just call that field..

so the calc field would look something like this

quote & "Wow, this is so cool." & quote

then when the calc field is displayed on the layout it should look like this.

"Wow, this is so cool."

------

oops, sorry i missed the end of you post about trying this already. oh well.. sorry, my bad..

[ May 14, 2001: Message edited by: bman ]

To enter a quote within a text definition, enter a double quote:

Example (calculation, text) =

"The following word ""example"" is in quotes"

-bd

  • Author

Thanks BMAN and LiveOak,

I'll give it a try...

--

Dodge

dude, Dodge, that is one wicked skull on your website. Got a temporarily down message but the skull was still pretty darn cool.

yafreax

(note to self: don't mess with Dodge)

  • Author

It sure is! laugh.gif" border="0

dodge

Create an account or sign in to comment

Important Information

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

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.