What Code Or Macro Can I Use To Substitute Text To Column

[Corried]

Hello Everyone.

Presently I have Many Raw Data below to section out.

What's beautiful, all the following data are similar:
Here is an example in row "1", in column "A" only :

0: {c: 9, close: 9, yield: null, referenceDate: null, date: "1997-03-01T00:00:00", …}

In this Case: How can I Keep the values of The following:

9	1997-03-01

I have multiple data similar like above. The comparison with the others are, values and dates.

What is the effective way to get the data?
Or what code can I use? How do you want me to proceed?

Thanks in advance

 

[Jon von der Heyden]

Pah! I should have read the post properly in the first instance. I just love the wow factor of this approach, when it works!

 

[Jon von der Heyden]

We can actually type in character 160 in the formula using num keypad ALT+0160

=LOOKUP(999999,--MID(A1,FIND("c: ",A1)+LEN("c: "),{1;2;3;4;6}))

and

=LOOKUP(99999,--MID(A1,FIND("date: """,A1)+LEN("date: """),{1;2;3;4;6;7;8;9;10}))

respectively

 

[Fluff]

Must admit I do like approach.
Now bookmarked for the future.

 

[Jon von der Heyden]

A good ol' Barry Houdini trick (perhaps not originally though)

 

[Corried]

Thank you very much for the support and swift reply. I am not sure if you all would agree with me. I just don't know. We speaking to someone and they have recommended power query.
A matter of fact I was surprise of the outcome.

If you are comfortable you take a look.

However, I will use your code as will when a problem do accur.

Thanks for everything. Below is the link:
Book3 (1).xlsx

 

[Fluff]

I know nothing about PQ as I have never used it, so cannot really comment.
But If it's easier to use that, then go for it.