FileMaker Pro Custom Functions

The following version adds in a few more important substitutions...

/* See http://www.faqs.org/rfcs/rfc2368.html for mailto specifications
The following substitutions and their order are important. mailto: will fail without them.
Reserved characterss in a mailto: URL are "-", "&", and "?"
Must escape the % first, before you start adding them in.
Then do spaces and returns.
Stupify quotes and other stuff
Non-breaking space
Does not handle double quotes or tabs (%09)
Could add substitutions for all diacriticals and other less common characters */

Substitute (text;
["%"; "%25"];
[ " "; "%20"];
["¶"; "%0D"];
[ "!" ; "%21" ] ;
[ "$" ; "%24" ] ;
[ "(" ; "%28" ] ;
[ ")" ; "%29" ] ;
[ "*" ; "%2A" ] ;
[ "+" ; "%2B" ] ;
[ "." ; "%2E" ] ;
[ "=" ; "%3D" ] ;
["\“"; "%22"];
[ "\”"; "%22"];
["‘"; "%27"];
["’"; "%27"];
["'"; "%27"];
["…"; "..."];
["•"; "*"];
[ "-"; "%2D"];
["&"; "%26"];
["="; "%3D"];
["?"; "%3F"];
["#"; "%23"];
[","; "%2C"];
[ "/"; "%2F"];
[":"; "%3A"];
[";"; "%3B"];
[ "<"; "%3C"];
[ ">"; "%3E"];
["@"; "%40&quo

Tim Cimbura, Minneapolis, MN
May 01, 2010 7:59pm

The above post got truncated. It won't work as displayed here.

Tim Cimbura, Minneapolis, MN
May 01, 2010 8:00pm

I added the german "Umlaute" whose are:

[ "A" ; "%C3%84" ] ;
[ "ä" ; "%C3%A4" ] ;
[ "Ö" ; "%C3%96" ] ;
[ "ö" ; "%C3%B6" ] ;
[ " Ü" ; "%C3%9C" ] ;
[ "ü" ; "%C3%BC" ] ;
[ "ß" ; "%c3%9F" ] )

Cheers

Alex

Alex, Berlin
March 31, 2011 2:01am

Of course it has to be "Ä" instead of "A"
and "Ü".

Alex, Berlin
March 31, 2011 2:04am