SQLite Forum

Split an Extract column
Login
```
with the_table (this_column)
  as (
      values ('{1,1,20210206000704,,,,,1772285065,10,(10)4045420,100230,N,1}'),
             ('{1,1,20210126033937,,,,,1772285065,10,(317)5757554,100236,N,1}'),
             ('{1,1,20210202030039,,,,,1772285065,10,(325)4092770,100208,N,1}'),
             ('{1,1,20210202170400,,,,,1772285065,10,(377)4040420,100230,N,1}'),
             ('{1,1,20210203031334,,,,,1772285065,10,(45)4098070,100208,N,1}')
     )
select this_column,
       replace(replace(json_extract(replace(replace(replace(this_column, '{', '["'), ',', '","'), '}', '"]'), '$[9]'), '(', ''), ')', '') as new_column
  from the_table
;
```