I have a flat file(.txt) generated from a web service having the contents something as below:
Field1 Field2
""key1": [{"somekey":"somevalue"}], "key2": "somevalue2" testvalueforfield2
As you can see from above structure Field1 of my flat file contains a JSON based response. I want the JSON response to be extracted and written to a .json file. I'm not able to extract the JSON response from my flat file. Can anyone help me so as to which transformations and/or components I must use to get this done ?
Update: I'm using a hierarchy parser to extract fields from my json value present in flat file but nothing comes up in the target file