pattern keywords

$0 first column
$1 second column etc.
$h0 heading of first column
$h1 heading of second column etc.
$-0 the last column
$-1 the second last column etc.
$row the entire row
$rowNum current row number (starts at 1)
$rowNumZero current row number (starts at 0)
$numRows the number of rows
$numFields the number of fields (columns) on this row
$once repeat this section once only
$each repeat this section for each row
$each+ skip header row and repeat for the rest
$dollar; literal '$' sign
<% ... %> embedded javascript

NimbleText
Cheat Sheet

useful javascript functions

Embed any javascript expression in <% ... %>

To UPPER Case .toUpperCase()
To lower Case .toLowerCase()
To Title Case .toTitleCase()
To PascalCase .toPascalCase()
To camelCase .toCamelCase()
To sentence case .toSentenceCase()
To words
(from PascalCase etc.)
.toWords()
Reverse .reverse()
Replace .replace(/[:;()+]/gm,' ')
Trim .trim()
Left Trim .ltrim()
Right Trim .rtrim()
Html Encode .htmlEncode()
Html Decode .htmlDecode()
Url Encode .urlEncode()
Url Decode .urlDecode()
XML Encode .xmlEncode()
Char At .charAt(3)
Index Of .indexOf(',')
Slice .slice(2,5)
Substr .substr(2,3)
Left .left(2)
Right .right(2)
Format Date new Date($0).format('dd mm yy')

commandline parameters

-p --pattern=VALUE specify a pattern
-i --inputdatafile=VALUE a filename for loading the input data
-f --patternfile=VALUE a filename for loading a pattern
-o --outputfile=VALUE a filename to store the results
-r --rowdelim=VALUE the row delimiter
-c --coldelim=VALUE the column delimiter
-q --qualifier=VALUE text qualifier character (defaults to double quote)
-l --includepadding include padding around fields (don't trim fields)
-j --jumpconsec treat consecutive field delimiters as one
-n --nonewline don't output a new line after each row
-e --includeemptyrows include empty rows (don't ignore them)
-g --gui show the Graphical User Interface
-? --help show this message and exit

misc.

Keyboard shortcuts
[F5]Execute
[Ctrl]+[Tab]Insert Tab
URLs
Use it online http://NimbleText.com/Live/
cheatsheet https://NimbleText.com/Info/Cheat
Download exe https://NimbleText.com/Download/NimbleText.exe