Search Results
37 functions found:
| 1. | Age ( dateCurrent ; dateBirth ) |
 Average rating:
0.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return age based on dateCurrent and dateBirth. | |
| 2. | AssignWindowName ( Text ) |
 Average rating:
4.8 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Add " - num" to Text when the Text is not unique in WindowNames. | |
| 3. | BytesHumanReadable ( Number ) |
| Average rating:
5.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Convert long numbers to short with measurement units. | |
| 4. | Commas ( Number ; Digit ) |
 Average rating:
4.7 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Insert commas into numbers. | |
| 5. | ConcatValues ( ValuesOriginal ; ValuesToConcatenate ; ColumnSeparator ; RowSeparator ) |
| Average rating:
0.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Concatenate values which has multiple rows and columns to other values. | |
| 6. | ConditionalSummary ( TypeField ; Type ; SumField ) |
| Average rating:
4.5 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Sum a SumField for records where TypeField matches | |
| 7. | CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp ) |
| Average rating:
3.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| List every table names of current file followed by count of records which modified within StartTimestamp and EndTimestamp. | |
| 8. | DateByNthDOW ( tYear ; tMonth ; tDayOfWeek ; tNum ) |
| Average rating:
4.2 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Pick Nth day of week in specified year and month. | |
| 9. | ErrorJP_11 ( ErrorCode ) |
| Average rating:
4.6 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return Description of specified Error Code of FMP11 in Japanese. | |
| 10. | EvalCalcInserts ( Text ) |
| Average rating:
3.9 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Replace " |
|
| 11. | FindValues ( Values ; Pattern ) |
| Average rating:
4.4 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return values including Pattern. | |
| 12. | GeneratePW ( Digit ; Option ) |
| Average rating:
4.5 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Generate random password string. | |
| 13. | GetAsQuotedPrintableDecoded ( EncodedText ) |
| Average rating:
0.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Decode Quoted Printable encoded strings. | |
| 14. | GetAsURLDecoded ( EncodedText ) |
| Average rating:
5.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Decode URL encoded text to UTF-8 strings. | |
| 15. | GetAsURLEncodedRFC3986 ( Text ) |
| Average rating:
0.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Add RFC3986 reserved characters to GetAsURLEncoded function (RFC2396). | |
| 16. | GetFrontPanels |
| Average rating:
4.1 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return object name(s) of every frontmost panel(s) on current layout. | |
| 17. | GetSourceFileName ( NameTableOccurrence ) |
| Average rating:
4.1 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return source file name by table occurrence name. | |
| 18. | Hash ( SourceText ; SaltText ; HashAlgorithm ; LengthToExpandSalt ; NumStretch ) |
| Average rating:
0.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Generate salted & stretched hex encoded hash string. | |
| 19. | ListColumnValue ( Value ; NumberOfColumn ; ColumnSeparator ; RowSeparator ) |
| Average rating:
4.7 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Get return-separated value of specified column in Value. Like List function for multi-column array. | |
| 20. | ListValues ( Field ) |
| Average rating:
4.2 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return return separated value of Field data in current found set. | |
| 21. | MatchValues ( Values ; Pattern ; StartsOrEndsOrPartialOrExact ) |
| Average rating:
5.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return values by matching Pattern with option (Starts with, Ends with, Partial, Exact). | |
| 22. | MilliTimestamp ( OffsetTimeFromUTC ) |
| Average rating:
4.6 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Get Timestamp data with milli-seconds. | |
| 23. | NthDOWbyDate ( tDate ) |
| Average rating:
4.7 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Pick Nth day of week in month of specified date. | |
| 24. | PickTag ( Text ; Prefix ; Suffix ) |
| Average rating:
4.7 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Pick strings between Prefix and Suffix with Prefix and Suffix itself. | |
| 25. | PickTagContent ( Text ; Prefix ; Suffix ) |
| Average rating:
4.6 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Pick strings between Prefix and Suffix without Prefix and Suffix itself. | |
| 26. | PositionValues ( Text ; Value ) |
| Average rating:
4.6 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return value number of Value in Text. | |
| 27. | QuoteTOName ( Field ) |
| Average rating:
4.7 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Pick TO name from FQFN and quote it for ExecuteSQL function. | |
| 28. | RemoveControlCode ( Text ) |
| Average rating:
0.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Remove control codes (ex. VT as in-cell return code of Excel). | |
| 29. | RemoveEmptyValues ( Text ) |
| Average rating:
4.5 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Remove empty lines of return-seperated text. | |
| 30. | RemoveValue ( Values ; ValuesToRemove ) |
| Average rating:
4.4 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Opposite version of FilterValues (). | |
| 31. | RepeatValue ( Text ; NumRepeat ) |
| Average rating:
4.5 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return return separated text of "Text" repeated "NumRepeat" times. | |
| 32. | ReplaceOnMultipleValues ( Value ; Start ; NumberOfCharacters ; ReplacementText ) |
| Average rating:
4.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Execute "Replace ()" function on each line of multiple lines. | |
| 33. | RoundBanker ( Number ; Precision ) |
| Average rating:
0.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Round numbers by "Banker's Rounding" (round half to even). | |
| 34. | SanitizeFieldName ( Field ) |
| Average rating:
0.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Return result of GetFieldName() and add "${" and "}" to field name if needed. | |
| 35. | SetVariable ( Variable ; Value ) |
| Average rating:
4.8 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Set local ( when you use in script step ) or global variable, conditionally. | |
| 36. | SortValue ( Value ; AscDes ) |
| Average rating:
4.0 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| Sort return-separated text. | |
| 37. | SQLFieldName ( Field ) |
| Average rating:
4.4 |
|
| Koji Takeuchi, TonicNote, Inc. | |
| This function is like GetFieldName () for ExecuteSQL function. Make FQFN quoted and dot separated for ExecuteSQL function. | |