Tag archive

#parse

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).

intermediate conversion MySQL MariaDB SQL Server PostgreSQL SQLite

Parse A Formatted String Into A Date

Convert a text string in a known format into a native DATE value using engine-specific parsing functions.