Text Expressions
From Keyfax Wiki
| Expression | Databox Value | Result | Comments |
|---|---|---|---|
| CSV(2) | line1, line2, line3 | line2 | Will return the specified section from within a CSV; (2) = 2nd entry (line2) Returns "" if entry is invalid. |
| Entry(2, ";") | line1; line2; line3 | line2 | Entry n (1-based) from list Returns "" if invalid entry. |
| Exists | "any text" | True | False if Value is Empty/Blank |
| Index(" line2",",") | line1, line2, line3 | 2 | Index (1-based) index of entry in list Returns 0 if not in list. Note: exact match required e.g. text case and spaces |
| Inlist("A,B,C", ",") | A or B or C | True | True if text is in list. Note: exact match required e.g. text case and spaces |
| Item("Name") | Keyfax address Databox | Name item from address | Item returns a named item from a multi-value Databox such as an Address or an SQL data source returning multiple columns where individual column values are returned using the column name e.g. Item("colName") |
| Len | "characters" | 10 | Measures the number of characters used within the Databox Value |
| ListTidy(";") | ";B;;D;" | "B;D" | Removes leading, trailing and duplicated occurrences of the given 'separator' |
| Lower | NAME | name | Changes an uppercase Value to lowercase |
| PadLeft(7, " ") | "12" | " 12" | Places an Indent to the left of the Value |
| Replace('B','X') | "ABCABC" | "AXCAXC" | Replace all occurrences of first value ('B') with second value ('X') |
| Substr(4,2) | 123456789 | 45 | 1st character = 1 |
| Trim | " text " | "text" | Trims the Value of any spaces |
| Upper | name | NAME | Changes a lowercase Value to uppercase |
| WCase | name | Name | Changes the start of the Value to uppercase |
