Link to home
Start Free TrialLog in
Avatar of zzdean
zzdean

asked on

File maker pro text formatting...

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
ASKER CERTIFIED SOLUTION
Avatar of irac
irac

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial