Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

UrlEncode ( text )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 3.6  (62 votes)
  Discuss this Custom Function

Jeremiah Small, Soliant Consulting
http://jsmall.us

Converts illegal and reserved URL characters into URL-legal hex code.

Sample Input:
"http://www.database.com/page.php?field=" & UrlEncode ( "¶ \"!#$%&'()*+,-./:;<=>?@[\\]^`{|}" )
Sample Output:
http://www.database.com/page.php?field=%0D%20%22%21%23%24%25%26%27%28%29%2A%2B%2C%2D%2E%2F%3A%3B%3C%3D%3E%3F%40%5B%5C%5D%5E%60%7B%7C%7D


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

A complete table of hexadecimal codes can be found here http://www.december.com/html/spec/ascii.html

Be aware that curly quotes (single and double) are high-ascii, and will not be converted with this function. If you need quotes, make sure your input is with straight quotes.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

5 most recent comments | Show all 8 comments

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

Alex, Berlin
March 31, 2011 2:04am

Added Extended Character set:

["¢" ; "%A2"] ;
["£" ; "%A3"] ;
["¥" ; "%A5"] ;
["|" ; "%A6"] ;
["§" ; "%A7"] ;
["«" ; "%AB"] ;
["¬" ; "%AC"] ;
["¯" ; "%AD"] ;
["º" ; "%B0"] ;
["±" ; "%B1"] ;
["ª" ; "%B2"] ;
["," ; "%B4"] ;
["µ" ; "%B5"] ;
["»" ; "%BB"] ;
["¼" ; "%BC"] ;
["½" ; "%BD"] ;
["¿" ; "%BF"] ;
["À" ; "%C0"] ;
["Á" ; "%C1"] ;
["Â" ; "%C2"] ;
["Ã" ; "%C3"] ;
["Ä" ; "%C4"] ;
["Å" ; "%C5"] ;
["Æ" ; "%C6"] ;
["Ç" ; "%C7"] ;
["È" ; "%C8"] ;
["É" ; "%C9"] ;
["Ê" ; "%CA"] ;
["Ë" ; "%CB"] ;
["Ì" ; "%CC"] ;
["Í" ; "%CD"] ;
["Î" ; "%CE"] ;
["Ï" ; "%CF"] ;
["Ð" ; "%D0"] ;
["Ñ" ; "%D1"] ;
["Ò" ; "%D2"] ;
["Ó" ; "%D3"] ;
["Ô" ; "%D4"] ;
["Õ" ; "%D5"] ;
["Ö" ; "%D6"] ;
["Ø" ; "%D8"] ;
["Ù" ; "%D9"] ;
["Ú" ; "%DA"] ;
["Û" ; "%DB"] ;
["Ü" ; "%DC"] ;
["Ý

Pacrox, Milano
September 16, 2012 5:21pm

...cont:

["Ý" ; "%DD"] ;
["Þ" ; "%DE"] ;
["ß" ; "%DF"] ;
["à" ; "%E0"] ;
["á" ; "%E1"] ;
["â" ; "%E2"] ;
["ã" ; "%E3"] ;
["ä" ; "%E4"] ;
["å" ; "%E5"] ;
["æ" ; "%E6"] ;
["ç" ; "%E7"] ;
["è" ; "%E8"] ;
["é" ; "%E9"] ;
["ê" ; "%EA"] ;
["ë" ; "%EB"] ;
["ì" ; "%EC"] ;
["í" ; "%ED"] ;
["î" ; "%EE"] ;
["ï" ; "%EF"] ;
["ð" ; "%F0"] ;
["ñ" ; "%F1"] ;
["ò" ; "%F2"] ;
["ó" ; "%F3"] ;
["ô" ; "%F4"] ;
["õ" ; "%F5"] ;
["ö" ; "%F6"] ;
["÷" ; "%F7"] ;
["ø" ; "%F8"] ;
["ù" ; "%F9"] ;
["ú" ; "%FA"] ;
["û" ; "%FB"] ;
["ü" ; "%FC"] ;
["ý" ; "%FD"] ;
["þ" ; "%FE"] ;
["ÿ" ; "%FF"] )

Pacrox, Milano
September 16, 2012 5:22pm

Note that the %25 substitution HAS TO BE FIRST in the list. That was not a casual placement by Brian. If it is further down the list then the "%" signs in the already converted characters will be substituted again and, for example "!" will become %21 then %2521. Learned this the hard way. Thanks Brian!

Oregondean, Oregon, of course!
May 28, 2013 3:24pm

TIP: There is another custom function for removing smart quotes (http://www.briandunning.com/cf/1115)

Chris Van Buren, UK
November 25, 2014 3:01am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 1 + 8 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions