Brian Dunning's FileMaker Custom Functions

Search Results

12 functions found:

1.   AddDollarFormat ( Number )
    Average rating: 4.2
  Jeremiah Small, Soliant Consulting, Inc.
  Turn unformatted number into dollars with commas rounded to nearest penny.
   
2.   ErrorToEnglish ( ErrorNum )
    Average rating: 3.6
  Jeremiah Small, Soliant Consulting, Inc.
  Translate FileMaker error codes to the English language description. Updated for 17. Includes legacy codes.
   
3.   HexToRGB ( Hex ; RGorB )
    Average rating: 4.2
  Jeremiah Small, Soliant Consulting, Inc.
  Returns a decimal integer that represents a color obtained by converting standard 6 character hexadecimal input.
   
4.   MatchPrefix ( theList ; thePrefix )
    Average rating: 4.5
  Jeremiah Small, Soliant Consulting, Inc.
  Returns first value in a list that matches the supplied prefix.
   
5.   MatchPrefixAll ( theList ; thePrefix )
    Average rating: 4.3
  Jeremiah Small, Soliant Consulting, Inc.
  Returns all values from a list that matches the supplied prefix.
   
6.   NumToAlpha ( integer )
    Average rating: 4.4
  Jeremiah Small, Soliant Consulting, Inc.
  Convert numbers to letters
   
7.   NumToHex ( integer )
    Average rating: 4.1
  Jeremiah Small, Soliant Consulting, Inc.
  Convert Base 10 number to Base 16
   
8.   PolygonArea ( xlist ; ylist )
    Average rating: 4.4
  Jeremiah Small, Soliant Consulting, Inc.
  Calculate area of a polygon from array of XY coordinates
   
9.   PolygonAreaHelper ( xlist ; ylist ; prevDep ; prevDMD ; i ; list
    Average rating: 4.5
  Jeremiah Small, Soliant Consulting, Inc.
  Helper function for PolygonArea
   
10.   SubstituteCaseInsensitive ( text ; searchString ; replaceString )
    Average rating: 4.5
  Jeremiah Hammond, DB Services
  Works just like FileMaker's Substitute( ) function, but case is ignored.
   
11.   UrlDecode ( text )
    Average rating: 3.8
  Jeremiah Small, Soliant Consulting, Inc.
  Decodes URL encoded text
   
12.   UrlEncode ( text )
    Average rating: 3.6
  Jeremiah Small, Soliant Consulting, Inc.
  Converts illegal and reserved URL characters into URL-legal hex code.
   

Under construction. Email me your wish list for improvements.