SQLite Forum

Split an Extract column
Login
Works perfect !!

SELECT 
BILLCHARGE_ID,
EXT_ATTR,
json_extract(replace(replace(replace(EXT_ATTR, '{', '["'), '}', '"]'), ',', '","'), '$[9]') AS EXPRESION,
   replace( substr( substr(EXT_ATTR, instr(EXT_ATTR, '(') + 1), 1, instr( substr(EXT_ATTR, instr(EXT_ATTR, '(') + 1), ',') - 1), ')', '') EXPRESION2
FROM BILL_CHARGE WHERE BILLCHARGE_ID=751000000157777658

BILLCHARGE_ID	EXT_ATTR	EXPRESION	EXPRESION2
751000000157777658	{,,,,,,,,,(11)24598458,100230,,1}	(11)24598458	1124598458


Thanks you all!!