Parse
Parse blocks turn text into data you can use: real dates and numbers, JSON unpacked into columns or rows, pieces of text extracted with a pattern and lists split apart.
Blocks in this palette
Turn text into dates and timestamps.
Turn JSON text into columns or rows.
Turn formatted text into numbers.
Extract text or flag a pattern.
Split text across columns.
Split text into rows.
Parse FAQs
- Should I split to columns or to rows?
- Split to columns suits a fixed set of parts, such as first and last name. Split to rows suits a list with a varying number of items, such as tags.
- How do I read JSON from a connector?
- Use the JSON block on the column that holds it. Unnest object makes columns; Flatten array makes rows.
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.