← All nodes
Text

Delimiter Encode / Decode

CSV-quotes, URL-encodes or HTML-escapes a column — or undoes it — so values survive the trip into a feed, a link or a web page.

When to use it

Use it before writing a hand-built feed or URL, or to read values that arrived encoded (%20, &, "quoted, fields").

In a pipeline

Settings

SettingTypeRequiredDefault or hint
ColumnselectYesSelect column…
Encodingselect—csv
Directionselect—encode
Generate New Columncheckbox—true
New Column Nametext—Default: <column> Encoded / Decoded
Insert Afterselect—After the column

Example

CSV-escape before a feed

  • Column=Title
  • Encoding=CSV field quoting
Products
Title
Tea, green
6" plate
Mug
Quoted where needed
TitleTitle Encoded
Tea, green"Tea, green"
6" plate"6"" plate"
MugMug

Worth knowing

  • CSV quoting is the exact rule Export CSV uses: quotes only when a comma, quote or line break needs them, with inner quotes doubled.
  • URL decoding also reads + as a space; values that are not valid encoding are left as they were and counted.
  • HTML decoding understands named (&amp;) and numbered (&#39;) entities.

Others in Text