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

URLDecode ( text )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 3.8  (53 votes)
  Discuss this Custom Function

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

Decodes URL encoded text

Sample Input:
URLDecode ( "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" )
Sample Output:
http://www.database.com/page.php?field=" & UrlEncode ( "¶ \"!#$%&'()*+,-./:;<=>?@[\\]^`{|}" )


 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:

Decodes URL encoded text

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:

Thanks for the great function, there should be a FM standard URLdecode function, but until then, this is great.

Here is the full list I'm using in multiple parts since there 's a 1500 character reply limit.


["%0D";"¶"];
["%20";" "];
["%21";"!"];
["%22";"\"& quot;];
["%23";"#"];
["%24";"$"];
["%25";"%"];
["%26";"&"];
[ "%27";"'"];
["%28";"("];
[&q uot;%29";")"];
["%2A";"*"];
["%2B ";"+"];
["%2C";","];
["%2D"; "-"];
["%2E";"."];
["%2F";"/ "];
["%3A";":"];
["%3B";";"] ;
["&lt;";""];
["%3D";"="];
["&gt;";""];
["%3F";"?"];
[&q uot;%40";"@"];
["%5B";"["];
["%5C ";"\\"];
["%5D";"]"];
["%5E" ;"^"];
["%5F";"_"];
["%60";" `"];
["%7B";"{"];
["%7C";"|" ];
["%7D";"}"];
["%7E";"~"];
[&q uot;%A0";" "];
["%A1";"¡"];
["%A2";"¢" ;];
["%A3";"£"];
["%A4";"¤"];
["%A5";"¥"];
["%A6";"¦"];
[&quo t;%A7";"§"];
["%A8";"¨"];
["%A9 ";"©"

Rakesh, Amsterdam
September 13, 2012 5:05pm

Part II

];
["%C0";"À"];
["%C1";"Á"];
[ "%C2";"Â"];
["%C3";"Ã"];
[" ;%C4";"Ä"];
["%C5";"Å"];
["%C6& quot;;"Æ"];
["%C7";"Ç"];
["%C8" ;"È"];
["%C9";"É"];
["%CA";&quo t;"];
["%CB";"Ë"];
["%CC";"Ì&qu ot;];
["%CD";"Í"];
["%CE";"Î"];
["%CF";"Ï"];
["%D0";"Ð"];
[&q uot;%D1";"Ñ"];
["%D2";"Ò"];
["% D3";"Ó"];
["%D4";"Ô"];
["%D5&qu ot;;"Õ"];
["%D6";"Ö"];
["%D7";& quot;×"];
["%D8";"Ø"];
["%D9";" Ù"];
["%DA";"Ú"];
["%DB";"Û&qu ot;];
["%DC";"Ü"];
["%DD";"Ý"];
["%DE";"Þ"];
["%DF";"ß"];
[&q uot;%E0";"à"];
["%E1";"á"];
["% E2";"â"];
["%E3";"ã"];
["%E4&qu ot;;"ä"];
["%E5";"å"];
["%E6";& quot;æ"];
["%E7";"ç"];
["%E8";" è"];
["%E9";"é"];
["%EA";"ê&qu ot;];
["%EB";"ë"];
["%EC";"ì"];
["%ED";"í"];
["%EE";"î"];
[&q uot;%EF";"ï"];
["%F0";"ð"];
[&q

Rakesh, Amsterdam
September 13, 2012 5:07pm

looks like you need to replace '&qu ot' with ' " '.

Don't think anyone needs these, but just incase.

["%30";"0"];
["%31";"1" ];
["%32";"2"];
["%33";"3"];
[&q uot;%34";"4"];
["%35";"5"];
["%36 ";"6"];
["%37";"7"];
["%38"; "8"];
["%39";"9"];

["%41";" ;A"];
["%42";"B"];
["%43";"C" ;];
["%44";"D"];
["%45";"E"];
[& quot;%46";"F"];
["%47";"G"];
["%4 8";"H"];
["%49";"I"];
["%4A" ;"J"];
["%4B";"K"];
["%4C";" L"];
["%4D";"M"];
["%4E";"N" ];
["%4F";"O"];
["%50";"P"];
[&q uot;%51";"Q"];
["%52";"R"];
["%53 ";"S"];
["%54";"T"];
["%55"; "U"];
["%56";"V"];
["%57";"W "];
["%58";"X"];
["%59";"Y"] ;
["%5A";"Z"];

["%61";"a"];
[& quot;%62";"b"];
["%63";"c"];
["%6 4";"d"];
["%65";"e"];
["%66" ;"f"];
["%67";"g"];
["%68";" h"];
["%69";"i"];
["%6A";"j" ];
["%6B";"k"];
["

Rakesh, Amsterdam
September 13, 2012 5:09pm

Code seems to get messed up a bit, so fix where needed like ["%41";"A"];

Rakesh, Amsterdam
September 13, 2012 5:13pm

For best results, move the [ "%25" ; "%" ] to the bottom of the list. Otherwise, if there are any embedded %'s they may be re-interpreted as an additional escape sequence.

Philip, Dallas
August 30, 2016 12:33pm

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 0 + 6 =
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. StopwatchMilliseconds ( StartTimeLapLapsStopClear , LapPrefix )
  (Fri, Jun 23, 9:46am)
2. StopwatchSeconds ( StartTimeLapLapsStopClear , LapPrefix )
  (Fri, Jun 23, 9:40am)
3. LinkedInLookup ( name )
  (Fri, Jun 23, 1:07am)
4. BaseX_ToDecimal ( baseString; decimalNumber )
  (Tue, Jun 20, 8:40am)
5. BaseX_FromDecimal ( baseString; decimalNumber )
  (Tue, Jun 20, 8:33am)
6. AutoPct ( myValue )
  (Thu, Jun 15, 12:07pm)
7. BarcodeCode128B_BMP_380px ( string )
  (Wed, Jun 14, 4:05pm)
8. FrontTabPanelNames ( param )
  (Tue, Jun 13, 5:46am)

RSS Feed of Custom Functions