To report a bug or make a suggestion, email Support omit this @ omit this NimbleText.com
This is the introductory help page. For detailed help, you probably need:
NimbleText is the world's simplest code generator. It formats your data using the patterns you supply.
There are three text boxes, and a button called 'Calculate'.
The first box contains your data. The second box contains your pattern. When you press calculate, the data is formatted using the pattern and the result is placed in the third box.
Data? What Data?
When I say 'The first box contains your data' I'm talking about any list of text. Perhaps you have a shopping list, or a spreadsheet. Any of these things can be pasted in the 'data' text box.
In technical terms the data is 'separated values' meaning there are rows and columns, where each column is indicated by some kind of delimiter (such as a comma) and each new row is indicated by a different kind of delimiter (such as a carriage return).
Here's some data that has seven rows and each row has only one column
Better yet, here's some data that has seven rows and each row has two columns
Spreadsheets, such as excel, are a good source of data. If you paste data in from Excel, it is usually separated with 'tab' characters, instead of commas, so it would look like this:
Data is abundant, omnipresent. But it doesn't want to stay in neat little columns. It ends up making its way into richer places. It becomes text, and data structures, and wonderful things like HTML and Code. That's where NimbleText helps out.
Applying a pattern...
Say we want to take our color information and produce some text like this:
Red is a color...and so on for each color.
Blue is a color
The pattern in this case is '
$0 is a color'
"$0" means "Whatever value is in the first column."
(When nerds count, we start at zero)
So if we put:
try it →
$0is a color
...in the pattern
text box, and press
Calculate we get:
red is a color
orange is a color
yellow is a color
green is a color
blue is a color
indigo is a color
violet is a color
Hmm, now that's not quite what we wanted. We wanted the first letter of each word to be capitalized.
To do this we can use one of the 'built-in' functions (they are typical functions that you need all the time when manipulating text).
We want to capitalize the first word, so we use the function 'To Sentence Case.' Here's our improved function:
try it → <% $0.toSentenceCase() %> is a color
The result of our improved function is:
Red is a color
Orange is a color
Yellow is a color
Green is a color
Blue is a color
Indigo is a color
Violet is a color
And we're done.
You can also get help on all the symbols and keywords, or on the built-in functions, filtering with a where clause, help with the powerful command-line automation, or applying custom formats to your dates and times.
- Symbols and Keywords
- Built-in Functions
- The 'Where' clause
- Date Time formatting
- Command-Line Automation
SQL Master Class
There is also a series of articles to help you use NimbleText to generate SQL.