Solved

File maker pro text formatting...

Posted on 1997-02-28
1
252 Views
Last Modified: 2013-12-03
Here is a small but seemingly insurmountable
problem that I am fishing for answers to:

I am trying to use FileMaker Pro to maintain a database
consisting of information to be exported to an HTML
document.  For ease of use I am attempting to have
filemaker automatically format all URLS.  For
example, someone typing:

email: bdimond@lerc.nasa.gov

I want automatically formated to:

email:<A HREF="mailto:bdimond@lerc.nasa.gov">bdimond@lerc.nasa.gov</A>

So far, I have managed to get the format I need by using
calculation fields to manipulate the text.  The only problem
is the damn quotation marks!  to date I have tried:

1. Putting the quotation marks into the calculation field,
   i.e. """, but the syntax checker will treat the extra
   quote as an open text string.

2. I then tried using putting the quote character into a
   global variable which would be swapped out with in
   a calculation via the substitute command.  Unfortunately,
   the applications smart quotes cannot be read properly
   as HTML text.

3. I then selected disabled "Use smart quotes" in the
   preferences panel, but the calculation result STILL
   used the smart quotes.

If ANYONE has some options on how to get filemaker to
insert regular quotes, I would be much obliged if they
would email me at: bdimond@lerc.nasa.gov.  Thank you.

Bob Dimond
0
Comment
Question by:zzdean
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
irac earned 100 total points
ID: 1539640
I tested the following html code with Netscape navigator 3.0

<A HREF=mailto:me@somewhere.place>Mail me!</a>

You don't need the quotes for mailto.  I am pretty sure you don't need quotes as long as your filename doesn't have any spaces or 'special' characters in it.

While this isn't the answer you were asking for, I think it will solve your troubles.  I will look on my web server server tomorrow and see if I can answer the question more fully in case you do need to use quotes because of special characters etc etc.  I guess that someone could break the above code when they entered an email name into a form with a space in the name. Of course the mail wouldn't send correctly even if you had working quotes, but it might error out better with the HTML if we had quotes.  As I said, I will look tomorrow and see what I can find.  Happy serving.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi Folks, This article is intended to throw some light or basically give an idea towards taking the first step in the world of Systems Administration. This would in the real context of the word "Systems Administration" which would mean right from…
A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question