| Template Help Note - the Template Engine evaluates text between { and } as Javascript and substitutes the expression value. | |
|---|---|
| Value | Description |
| Heading and Fields Variables | |
| {h1} {h2} {h3} .... | Heading for field 1,2,3 ... |
| {H1} {H2} {H3} .... | Heading for field 1,2,3 as upper case... |
| {f1} {f2} {f3} .... | Field value 1,2,3 ... or you can use the name of the field in the heading |
| {F1} {F2} {F3} .... | Field value 1,2,3 as upper case... |
| {fieldname} |
Alternative to {f1},{f2}... use the field name instead. i.e. {id},{amount}
NOTE - use the FUNCTIONS below, i.e. {name.toJson()} if you need to encode the data |
| String Constants and Counters | |
| {nf} | Number of fields in current row |
| {nr} | Number of data rows in CSV before filtering |
| {nh} | Number of fields in heading row |
| {rn} | Current data row number |
| {br} | Line break |
| {lb} | Left bracket { |
| {rb} | Right bracket } |
| {seq} | Sequence 1,2,3,... |
| {tab} | Tab |
| Functions | |
| {f1.function()} |
Where function is a valid Javascript string method or built-in function.
Multiple functions are supported via appending to the end (i.e. f1.trim().toUpperCase()). Partial list of functions below. |
| {f1.toUpperCase()} | Field value to upper case letters |
| {f1.toLowerCase()} | Field value to lower case letters |
| {f1.toCsv()} | convert field to a CSV field by enclosing in double-quotes. |
| {f1.toDollar()} | Format field value as dollar amount |
| {f1.toFixed(n)} | Field value to numeric value with n decimal places |
| {f1.toHtml()} | Make field suitable for viewing as HTML |
| {f1.toInteger()} | Field value to integer value |
| {f1.toJson()} | Make field suitable for JSON value |
| {f1.toNumber()} | Field value to numeric value |
| {f1.rpad(n)} | Right pad field value with spaces until n characters long |
| {f1.lpad(n)} | Left pad field value with spaces until n characters long |
| {f1.ltrim()} | Trim spaces from left side of field |
| {f1.rtrim()} | Trim spaces from right side of field |
| {f1.rjust(n)} | Right justify text to size n. i.e. {f1.rjust(20)} |
| {f1.ljust(n)} | Trim and Left justify text to size n. i.e. {f1.ljust(20)} |
| {f1.rjust(n)} | Trim and Right justify text to size n. i.e. {f1.rjust(20)} |
| {f1.enclose(ch)} | Enclose field by character ch |
| {f1.cjust(n)} | Trim and Center justify text to size n. i.e. {f1.cjust(20)} |
| {f1.left(n)} | Return n characters from left side of field |
| {f1.right(n)} | Return n characters from right side of field |
| {f1.trim()} | Trim spaces from both sides of field |
| {f1.toSql()} | Make field suitable for SQL string value |
| {f1.toXml()} | Make field suitable for viewing as XML |
| {f1.startsWith(s)} | Field starts with string s, i.e. f2.startsWith('Jo'). Returns true or false. |
| {f1.endsWith(s)} | Field end with string s, i.e. f2.endsWith('son'). Returns true or false. |