How to Use SPLIT_PART in Redshift

Last updated July 25, 2026 · By the SaturnSQL team

SPLIT_PART(string, delimiter, position) splits a string on a delimiter and returns the Nth piece (1-based). It returns an empty string, not NULL, when the position is past the last piece.

SELECT SPLIT_PART('[email protected]', '@', 2) AS domain; -- example.com

SELECT SPLIT_PART(page_url, '/', 4) AS section,
       COUNT(*) AS views
FROM events
GROUP BY 1
ORDER BY views DESC;