Tag archive

#split

Commands grouped around the same concept, pattern, or recurring problem.

2 commands with this tag Browse related patterns quickly

intermediate string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Extract the Nth Field From a Delimited String

Pull out a specific token from a dot- or delimiter-separated string using `SPLIT_PART` (PostgreSQL), `SUBSTRING_INDEX` (MySQL/MariaDB), `PARSENAME` (SQL Server), or nested `SUBSTR`/`INSTR` (SQLite).

advanced string-processing SQL Server PostgreSQL

Split A Delimited String Into Rows

Expand a comma-separated or delimited string into one row per element, turning a single cell into a proper set of rows.