Functions
- 2 Minutes to read
- Print
- DarkLight
- PDF
Functions
- 2 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
See Also
| STRLENGTH(A) | |
| A | Name of string field |
| Result | A field containing the length of field A |
| CONCAT(A,B,C,D,E,F) | |
| A | Name of string field or #immediate value |
| B | Name of string field or #immediate value |
| C | Name of string field or #immediate value |
| D | Name of string field or #immediate value |
| E | Name of string field or #immediate value |
| F | Name of string field or #immediate value |
| Result | A new string field containing each argument string joined together |
| Note | A minimum of 1 field or value is required |
| CTOD(A) | |
| A | Name of string field |
| Result | Attempts to create a new discrete field, usally by having applied a filter to a continuous string. |
| Note | The defaut discrete threshold is 300,000 unique values. This can be overriden in the JSON with the number key "MAX_ENTRIES". Ranging from >1024 to < 1,000,000 |
| DATEFROMSTRING(A,B) | |
| A | Name of string field |
| B | Date format of string field |
| Result | Produce a date field from a date stored as string. |
| Note | Supported Formats are YYYY-MM-DD YYYYMMDD MM-DD-YYYY MMDDYYYY DD-MM-YYYY and DDMMYYYY. See Programmed Field and Expressions for other format processing |
| EXTRACTJKEY(A,B,C) | |
| A | Name of string field |
| B | Key value |
| C | required width of target field |
| Result | A new string field containing the value of the string for Key |
| Note | The function will automatically replace single quoted key/value pairs with double quoted. |
| EXTRACTIJKEY(A,B) | |
| A | Name of string field |
| B | Key value |
| Result | A new integer field containing the value of the string for Key |
| Note | The function will automatically replace single quoted key/value pairs with double quoted. |
| FIRSTPOPULATED(A,B,C,D,E,F) | |
| A | Name of string field or #immediate value |
| B | Name of string field or #immediate value |
| C | Name of string field or #immediate value |
| D | Name of string field or #immediate value |
| E | Name of string field or #immediate value |
| F | Name of string field or #immediate value |
| Result | A new string field containing the value from the first field from A to F that is non null/empty |
| Note | A minimum of 1 field or value is required |
| LEFT(A,B) | |
| A | Name of discrete string field |
| B | Number of characters |
| Result | A new string field containing up to the first B characters of field A |
| RIGHT(A,B) | |
| A | Name of discrete string field |
| B | Number of characters |
| Result | A new string field containing up to the last B characters of field A |
| LEFTOF(A,B) | |
| A | Name of discrete string field |
| B | Character |
| Result | A new string field containing all characters to the left of the first occurrence of characters B |
| RIGHTOF(A,B) | |
| A | Name of discrete string field |
| B | Character |
| Result | A new string field containing all characters to the right of the first occurrence of characters B |
| LPAD(A,B,C) | |
| A | Name of discrete string field |
| B | Size of padding |
| C | Character to pad |
| Result | A new string field containing the original string if B copies of character C prepended |
| REPLACE(A,B,C) | |
| A | Name of discrete string field |
| B | Original string |
| C | Replacement string |
| Result | A new string field where all occurences of the string B are replace with the string C |
| WILDICAST(A) | |
| A | Name of discrete or continuous string field |
| Result | A new integer field where containing valid integer values from the string field |
Was this article helpful?