Extract text between delimiters

[pedrobeltramese]

Hi everyone!

 I'm new on Alteryx and I'm trying to get some information inside some delimiters. Here is an example:

What I've:

What I want:

Code	Name	City
1234	Test
	5678	SP

How can I do it?

Thank you in advance.

[KimLamNg]

@pedrobeltramese Attached is one way to do that.

[binuacs]

@pedrobeltramese try with the JSON Parse tool

[cjaneczko · Accepted solution]

Is your Name 5678 supposed to be Code? See attached. 

[pedrobeltramese]

No, it wasn't supposed to be code, it was supposed to be name as you said. I fixed the post and I'll try your solution.