Text Formatter

Lede. Transforms text – case, padding, replace, regex, date formatting, custom rules – before it reaches the placeholder.

Group: Formatter · Available in: all text-bearing workspaces · Central node: No

Purpose

• Force a column value to uppercase / lowercase / title case.
• Pad a number to a fixed width.
• Replace substrings (e.g. strip EUR before display).
• Apply a regex to clean or extract part of a string.
• Apply a date format to an ISO date column.
• Compose multiple transformations in a single node.

Where to find it

Add Node ▸ Style ▸ Format

How it works

The node configures one or more Options (each is a single transformation rule, e.g. "uppercase", "replace", "regex"). On evaluation, the rules run in order against the input value.

Wire the node’s Format output into another node’s Format socket (Data Text, Static Text, Sequence, Placeholder, …). Multiple formatters can be chained into the same Format socket – they apply in connection order.

The node also has an In socket. Wiring values into In lets the formatter receive an upstream value directly – mostly useful for pre-formatting chains. Multiple inputs are accepted and concatenated.

Sockets

Settings

Example (end-to-end)

Scenario. A price column 19.99 should display as EUR 19.99 with two decimal places.

Wiring.

[Data Text: Price] → [Placeholder.Content]
[Text Formatter: prefix "EUR ", number pattern "0.00"] → [Placeholder.Format]

Empty / error behaviour

• Empty input: most rules return empty output silently. The placeholder’s empty-handling kicks in further downstream.
• An invalid regex pattern is flagged in the settings panel; the node becomes invalid.

Limitations

• Rules run in fixed order – effectively a pipeline. To branch by condition, use a Condition node ahead of the formatter.
• One formatter directive per node, but multiple formatter nodes can be chained.

Common pitfalls

• Rule order matters. Lowercase + replace produces different results than replace + lowercase.
• Applies twice. Inside a Repeater, a formatter wired into the placeholder formats the joined string; one wired into the per-row data chain formats each row.

Related nodes

• Data Text, Static Text, Data Text (table), Sequence, Placeholder – Text – all expose a Format socket.

Screenshots

📷 Screenshot [NEU]: Text Formatter settings (Options list) 📷 Screenshot [NEU]: Text Formatter chained into a Data Text → Placeholder