Split OpenAi output into own fields

We are working with the OpenAI output and need to split the data into its own columns. The data is contains an output for rating which we need to be in its own column for further use.
What is the best method to do this?

Can you share what the response from the API looks like? That would make it easier to help you.

There’s usually a newline /n between texts and code is place inbetween ``` characters.