Brian Dunning's FileMaker Custom Functions

Search Results

21 functions found:

1.   AddTimes ( Time1 ; Time2 )
    Average rating: 4.7
  Bill Thurmes, MDCA
  Add two times, in h:mm:ss format, together
   
2.   Contains ( Text ; SearchStrings )
    Average rating: 4.4
  Bill Thurmes, MDCA
  Determine whether Text contains any of the strings contained in SearchStrings ('or' logic)
   
3.   ContainsAll ( Text ; SearchStrings )
    Average rating: 4.6
  Bill Thurmes, MDCA
  checks to see whether all values in SearchStrings are contained in Text
   
4.   ContainsAllExact ( Text ; SearchStrings )
    Average rating: 4.5
  Bill Thurmes, MDCA
  Checks whether all values in SearchStrings are exactly (capitalization) found in Text
   
5.   ContainsExact ( Text ; SearchStrings )
    Average rating: 3.5
  Bill Thurmes, MDCA
  checks whether at least one of the values in SearchValues is an exact match for a portion of Text
   
6.   DeleteValue ( VList ; VNo )
    Average rating: 4.7
  Bill Thurmes, MDCA
  Removes a value from a value list
   
7.   FullList ( Field ; NumberOfReps )
    Average rating: 4.7
  Bill Thurmes, MDCA
  FullList is like List, except that it includes repetitions that are empty or zero.
   
8.   MaxListValue18 ( lst ; Type_1Text_2Numb_3Date_4Time_5TS )
    Average rating: 0.0
  Bill Thurmes, MDCA
  Determines the maximum value from a ¶-delimited value list, depending on data type, and requires FileMaker 18 or later
   
9.   MinListValue18 ( lst ; Type_1Text_2Numb_3Date_4Time_5TS )
    Average rating: 0.0
  Bill Thurmes, MDCA
  Determines the minimum value from a ¶-delimited value list, depending on data type, and requires FileMaker 18 or later
   
10.   PutValue ( ValueList ; ValueNumber ; ReplaceString )
    Average rating: 5.0
  Bill Thurmes, MDCA
  Replaces a designated value in a value list with another value
   
11.   PutValue18 ( ValueList ; ValueNumber ; ReplaceString )
    Average rating: 0.0
  Bill Thurmes, MDCA
  Replaces a designated value in a value list with another value
   
12.   SplitLists18 ( CompoundList ; Delimiter )
    Average rating: 0.0
  Bill Thurmes, MDCA
  Takes an array and moves rows to columns and columns to rows; breaks a typical EQSL result into columns
   
13.   SQLRefSimple ( FldRef ; Option1TO2Fld3Both )
    Average rating: 3.0
  Bill Thurmes, MDCA
  Makes it possible to refer indirectly to field and table occurrence names in SQL queries
   
14.   SubtractTimes ( Time1 ; Time2 )
    Average rating: 4.8
  Bill Thurmes, MDCA
  Subtract one time from another; both times in h:mm:ss format
   
15.   ValCorrelationCoeff ( XValueList; YValueList; Xmean; Ymean; XStdDev; YStdDev )
    Average rating: 4.5
  Bill Thurmes, MDCA
  calculates the correlation coefficient for a least-squares fit
   
16.   ValLeastSquaresSlope ( XValueList; YValueList; Xmean; Ymean )
    Average rating: 3.5
  Bill Thurmes, MDCA
  Calculates the slope of a set of X,Y pairs by least squares fit
   
17.   ValStdDev( ValueList ; ArithMeanValue )
    Average rating: 4.4
  Bill Thurmes, MDCA
  Gives the standard deviation of a value List of numbers
   
18.   ValStdDevS( ValueList ; ArithMeanValue )
    Average rating: 4.1
  Bill Thurmes, MDCA
  Gives the standard deviation of a sample, where the set of numbers are in a value list
   
19.   ValueArithmetic ( List1 ; List2 ; operation )
    Average rating: 5.0
  Bill Thurmes, MDCA
  Does basic arithmetic between two value lists, doing one operation (add, subtract, multiply, divide, raise) at a time
   
20.   ValueMath ( List1 ; List2 ; operation )
    Average rating: 3.3
  Bill Thurmes, MDCA
  Do mathematical calculations on corresponding members of two value lists
   
21.   ValueMean ( ValueList )
    Average rating: 4.7
  Bill Thurmes, MDCA
  Gives the mean / average of a value List of numbers
   

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: