Jump to content
Tapper

How to add parentheses to part of a Calc field

Recommended Posts

Tapper

Hi. I need to incorporate parentheses into a text calculation field that loads into a web browser. Does anyone know how to do this? Essentially:  "URL" & Address, but I need the address to field to have parentheses around it.

Share this post


Link to post
Share on other sites
AHunter3

"URL" & "(" & Address & ")"

 

 

  • Like 1

Share this post


Link to post
Share on other sites
Tapper

Hi. Boy do I feel stupid. I meant quotes around an address field. Is this possible in Filemaker?

Edited by Tapper

Share this post


Link to post
Share on other sites
Tapper

Got it. I just used Quote. I replaced blank spaces in the address field with the ASCII equivalent of %20 for proper loading of the URL in a browser. So now it reads https://URL&keywords="751%20E.%2014th%20Pl." But when it gets passed to the browser the double quotes are missing and the page doesn't load properly. Anybody know why?

Share this post


Link to post
Share on other sites
Tapper

I can copy and past the entire URL and the quotes remain. But if I setup a button to OpenURL then the quotes are not passed to the browser. Puzzling. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Terms of Use