SQLite Forum

Split an Extract column
Login
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
```