Parsing text into tables

[Giantstride]

Hi

Please I have this text 

{"identifiers":[{"value":"310000274","scheme":"person.v1.human-resources.university.identifiers.gmail.com"},{"value":"98bd4","scheme":"v1.person.identifiers.gmail.com"}],"namePrefixes":"Dr","surname":"Greta","forenames":"Stone","dateOfBirth":"1972-0...

and I want it to be in this format

Name prefix	surname	fornames	Data of birth	value
Dr	Greta	Stone	1972-0	310000274

Any help to transform it?

[FinnCharlton · Accepted solution]

@Giantstride , this is in JSON format, which means the JSON parse tool will be useful for parsing this. Here is a simple way to do it: