``` 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 ; ```