If your column value is literally as you have shown, then you could combine John's solution with something like this: ```bash sqlite> SELECT json_extract(replace(replace(replace(your_csv_column, '{', '["'), '}', '"]'), ',', '","'), '$[9]') ...> FROM (SELECT '{1,1,20210206000704,,,,,1772285065,10,(10)4045420,100230,N,1}' your_csv_column ...> UNION ALL SELECT '{1,1,20210126033937,,,,,1772285065,10,(317)5757554,100236,N,1}' ...> UNION ALL SELECT '{1,1,20210202030039,,,,,1772285065,10,(325)4092770,100208,N,1}' ...> UNION ALL SELECT '{1,1,20210202170400,,,,,1772285065,10,(377)4040420,100230,N,1}' ...> UNION ALL SELECT '{1,1,20210203031334,,,,,1772285065,10,(45)4098070,100208,N,1}'); (10)4045420 (317)5757554 (325)4092770 (377)4040420 (45)4098070 ```