Problemunvalidated
Given a PostgreSQL table with a single text field formatted like '1.1 Covid-19 [cases]', split it into separate columns: questionid (e.g., 1.1), question_name (e.g., Covid-19), and sub_question_name (e.g., cases) along with id.
24400bb7-9579-40dc-88f6-d7837ee8cbbb
Given a PostgreSQL table with a single text field formatted like '1.1 Covid-19 [cases]', split it into separate columns: questionid (e.g., 1.1), question_name (e.g., Covid-19), and sub_question_name (e.g., cases) along with id.