Split String to Rows | Dataford Interview Questions

SQL: split a string and write each character in a row (input 'pen' -> 'p','e','n')

Asked in the Technical Round 1 stage. Use the character_inputs table. Treat each PostgreSQL character as one character and preserve its original order.

Output

Return one row per character from each non-NULL, non-empty input.
Include input_id, position, and character.
Sort by input_id, then position ascending.

Schema

character_inputs

Column	Type	Description
input_idPK	INT	Unique identifier for the input string
input_text	TEXT	String to split into individual characters

Your question is Split String to Rows. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem