Text
Word / Paragraph Tools
Splits text into words, lines or n-grams — one row each — or counts the words in a column.
When to use it
Use it to tokenise addresses or names for matching, to count keyword frequency with Summarize, or to break a notes field into its lines.
In a pipeline
File InputWord / Paragraph ToolsSummarize (Multi-Aggregate)
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Mode | select | — | split |
| Words are separated by | text | — | Blank: any spaces. Or , or ; or \t |
| Words per n-gram | number | — | 2 |
| Generate New Column | checkbox | — | true |
| New Column Name | text | — | Default: <column> Word / Line / N-gram / Words |
| Insert After | select | — | After the column |
Example
Words of an address, one per row
- Column=Address
- Mode=One row per word
| Site | Address |
|---|---|
| HQ | 1 Market St |
| Site | Address | Address Word |
|---|---|---|
| HQ | 1 Market St | 1 |
| HQ | 1 Market St | Market |
| HQ | 1 Market St | St |
Worth knowing
- Words are separated by any spaces unless you type a separator (\t for a tab).
- N-grams are runs of n neighbouring words: "1 Market St" with n = 2 gives "1 Market" and "Market St".
- A blank cell is kept once; the node refuses to make more rows than the server's row limit.
- Count the words adds a number column instead of new rows.