What formula to use to parse this text column into usable columns for Google Sheets

[geperi]

I have the following text string: {"CAD":1.404,"EUR":0.925,"MXN":25.103,"USD":1,"SGD":1.433,"AUD":1.649,"GBP":0.813}
and I'd like to parse it so that it shows up in a few columns, like this:

CAD

1.404

EUR

0.925

MXN

25.103

USD

1

SGD

1.433

AUD

1.649

GBP

?0.813

What would be the simplest way to achieve this?

 

[Fluff]

I am trying to get CAD and all the other values

That's what the formula does do.

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	{"CAD":1.404,"EUR":0.925,"MXN":25.103,"USD":1,"SGD":1.433,"AUD":1.649,"GBP":0.813}	CAD	1.404	EUR	0.925	MXN	25.103	USD	1	SGD	1.433	AUD	1.649	GBP	0.813
Main

Cell Formulas
Range	Formula
B2:O2	B2	=TEXTSPLIT(SUBSTITUTE(A2,"""",""),{",",":","{","}"},,1)
Dynamic array formulas.