Shape · Text

Base64

Encodes a column to base64 text, or decodes base64 back to text or raw bytes.

Also known as: Encode, decode

How it works

Pick the Column and a Direction. Encode turns text (as UTF-8) or a binary column into base64 text. Decode turns base64 back into UTF-8 text, or into raw bytes when Keep as bytes (BLOB) is ticked. A value that is not valid base64, or decodes to something that is not UTF-8 when text is requested, becomes null and the node reports how many values it lost. Output column blank writes in place.

Inputs and outputs

Settings

{
  column: string
  direction: "encode"|"decode"
  decodeToBytes?: boolean
  outputColumn?: string
}

Example

An API dump holds a payload column of base64 JSON. Decode payload into payload_json, then read the fields out of the text.

More in Text

• Text Operations — Cleans text columns: change case, trim spaces, find and replace, pad, cut, add a prefix or suffix, or take the length. One node can clean several columns.
• Regex Extract — Pulls pieces out of text with a regular expression, one new column per capture group, such as a postcode from an address.
• Tokenize — Finds every match of a regular expression in a text column, such as each number in 'a12 b34'. It spreads the matches across columns, gives each its own row, or turns each match's capture groups into columns.
• URL Parse — Splits a web address into its parts: scheme, host, port, path, query and fragment. For example, pull the domain out of referrer links.
• IP Parse — Splits IPv4 or IPv6 addresses and network ranges into host, family, netmask, network and broadcast address. Handy for grouping traffic by subnet.
• Slug — Turns text into a web-friendly form: lower case, no accents, hyphens between words. 'Hello, World! 2026' becomes 'hello-world-2026'.