Hello,
please help if possible. i am trying to split this dictionairy {“status”: “completed”, “source”: {“country”: “US”, “state”: “CA”, “zip code”: 000000}, “paid”: false"} into smaller pieces.
Does anyone know what function to use here? I would like to only split the “CA” so i just want to have “CA” in a column.
I tried using the SELECT SPLIT() function but i seem to be off.
Does anyone know another way maybe?
please and thank you