Parse data in plain text?

[onurbolaca]

Hi,

I have plain text as data, the data involves questions and answers. This can be think as key/value. and I want to parse this plain text into JSON. Do you know how I can do this in make? I can do it in javascript.

My plain text data is only a question and answer flow like this;

Question: Answer

Question: Answer

[Runcorn]

Hi @onurbolaca,

Not sure about how your desired output JSON looks like, but the simplest way you can do is using iterator and text aggregator.

1. Setup Iterator that will split the plain text you are getting using newline
   
2. Setup the Text Aggregrator, that will split the result using colon as the seperator.

“{{trim(first(split(2.value; “:”)))}}” : “{{trim(last(split(2.value; “:”)))}}”

This implementation has few issues, also add a filter in between iterator and aggregator to check if the text is empty.

[Michaela]

Hello again @onurbolaca

Any luck putting @Runcorn’s proposed flow to work? Did it maybe help you accomplish what you’re been trying to do?

We’re eager to hear how things are coming together and would love an update on your progress

[onurbolaca]

This approached worked for me and helped me a lot.

I parsed as key and value with the static structure of my text.

It became something like this: