Search Results
44 functions found:
| 1. | Asc ( char ) |
| Theo Ros | |
| Returns the Ascii code for the given character | |
| 2. | BitChange ( value ; bit ) |
| Theo Ros | |
| Toggles a bit in a value | |
| 3. | BitClear ( value ; bit ) |
| Theo Ros | |
| Clears a bit in a value | |
| 4. | BitSet ( value ; bit ) |
| Theo Ros | |
| Sets a bit in a value | |
| 5. | BitTest ( value ; bit ) |
| Theo Ros | |
| Checks if bitnumber 'bit' in value 'value' is on or off | |
| 6. | CalendarDiff ( thedate ; gregorian ) |
| Theo Ros | |
| Returns the number of days between a the Julian Calendar for a given date and the Gregorian Calendar | |
| 7. | Chr ( ascii ) |
| Theo Ros | |
| Returns the character for the given ascii value | |
| 8. | DateToJD ( thedate ; gregorian ) |
| Theo Ros | |
| converts a date into a Julian Day number | |
| 9. | DateToSortableText ( thedate ) |
| Theo Ros | |
| Returns a sortable textual representation of a date value | |
| 10. | DayNameList ( LocaleID ) |
| Theo Ros | |
| Returns a list of Day names according to the given LocaleID | |
| 11. | DaysToNextBirthday ( birthdate ) |
| Theo Ros | |
| Returns the number of days to the next birthday | |
| 12. | DeleteValue ( list ; index ) |
| Theo Ros | |
| Returns a list with value at position 'index' removed | |
| 13. | FieldRepeats ( repeatingField ; 1 ) |
| Theo Ros | |
| Returns the true number of repetitions for a repeating field | |
| 14. | FieldRepeatsByName ( "fieldName" ) |
| Theo Ros | |
| Returns the true number of repetitions for a repeating field | |
| 15. | FindValues ( list ; searchString ; matchcase ) |
| Theo Ros | |
| Returns a list of all values from the original list that contain the given search string. | |
| 16. | FirstMonday ( themonth ; theyear ) |
| Theo Ros | |
| Returns the date for the first Monday in a given month | |
| 17. | FlipDigits ( value ) |
| Theo Ros | |
| flips decimal digits for textual sort purposes | |
| 18. | FormatDateLocale ( thedate ; formatstring ; LocaleID ) |
| Theo Ros | |
| Formats a date according to a Format string and a given language ID | |
| 19. | Fraction ( number ) |
| Theo Ros | |
| Returns a number as fraction text. | |
| 20. | GrayScale ( color ) |
| Theo Ros | |
| Returns the given color turned to grey as compound RGB color | |
| 21. | HexToDec ( hexString ) |
| Theo Ros | |
| converts a hexadecimal number string into a decimal number | |
| 22. | InsertValue ( list ; value ; index ) |
| Theo Ros | |
| Returns a list with value 'value' inserted at position 'index' | |
| 23. | InverseColor ( color ) |
| Theo Ros | |
| Returns the negative color for a compound RGB color | |
| 24. | IPToSortableText ( IPaddress ) |
| Theo Ros | |
| Returns a sortable textual representation of an IPaddress. | |
| 25. | IsValidBankNumber ( banknummer ) |
| Theo Ros | |
| Checks a Dutch banknumber for validity. | |
| 26. | IsValidIP ( IPaddress ) |
| Theo Ros | |
| Checks if 'IPaddress' contains a valid IP address. | |
| 27. | IsValidSofiNumber ( sofinummer ) |
| Theo Ros | |
| Checks a Dutch sofinumber for validity. | |
| 28. | JDToDate ( JulianDayNumber ; gregorian ) |
| Theo Ros | |
| converts a Julian Day number into a Filemaker date | |
| 29. | JoinRepetitions ( repeatingField ; delimiter; start ; nRepeats ) |
| Theo Ros | |
| Returns all repetitions in the repeating field as combined string | |
| 30. | LastMonday ( themonth ; theyear ) |
| Theo Ros | |
| Returns the date for the last Monday in a given month | |
| 31. | ListIndex ( list ; string ; matchcase ) |
| Theo Ros | |
| Seaches a list and returns the indexnumber if found | |
| 32. | MaxValue ( lst ; value ) |
| Theo Ros | |
| Returns the largest value in the list | |
| 33. | MinValue ( lst ; value ) |
| Theo Ros | |
| Returns the smallest value in the list | |
| 34. | MonthLen ( themonth ; theyear ) |
| Theo Ros | |
| Returns the number of days in the given month of the given year | |
| 35. | MonthNameList ( LocaleID ) |
| Theo Ros | |
| Returns a list of Month names according to the given LocaleID | |
| 36. | NamedColor ( colorname ) |
| Theo Ros | |
| Allows you to use CSS colornames instead of RGB() function | |
| 37. | NextMonday ( thedate) |
| Theo Ros | |
| Returns the date for the next Monday from the given date | |
| 38. | NumToSortableText ( value ; decimals ) |
| Theo Ros | |
| returns a textual representation of a number for sort purposes | |
| 39. | PositionX ( text ; searchString ; start ; occurrence ; matchcase ) |
| Theo Ros | |
| extended Position() function that can also work Case Sensitive | |
| 40. | SortValues ( list ; sortAscending ) |
| Theo Ros | |
| Sorts the values in a list ascending or descending | |
| 41. | Space ( len ) |
| Theo Ros | |
| Returns string of 'len' spaces | |
| 42. | StrMatch ( string1 ; string2 ; comparemethod ; matchcase ) |
| Theo Ros | |
| StrMatch makes it easier to compare to textfields. | |
| 43. | SwapValues ( list ; value1 ; value2 ) |
| Theo Ros | |
| Swaps two items in a valuelist | |
| 44. | ZeroNum ( number ; len ) |
| Theo Ros | |
| Returns a number with leading zeroes | |