SQLite Forum

Split an Extract column
Login
Hello, iam trying to split and extract the phone number FROM this COLUMN:

{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}

To a new column like:
104045420
3175757554
3254092770
454098070

can you help me?
Thanks!