https://community.cloudera.com/t5/Support-Questions/nifi-incorrect-json-format-correction/m-p/232991#M194824 <A rel="user" href="https://community.cloudera.com/users/56179/muratmentese.html" nodeid="56179" target="_blank">@Murat Menteşe </A><P>You can use <STRONG>ReplaceText </STRONG>processor after TransformXml processor then add the matching regex excluding "(quotes) before/after array [].</P><P><STRONG>ReplaceText Configs:-</STRONG></P><P>Search Value </P><DIV><PRE>(.*)"(\[.*\])"(.*)</PRE> </DIV><P>Replacement Value </P><DIV><PRE>$1$2$3</PRE> </DIV><P>Character Set </P><DIV><PRE>UTF-8</PRE> </DIV><P>Maximum Buffer Size </P><DIV><PRE>1 MB //increase the size according to your flowfile size</PRE> </DIV><P>Replacement Strategy </P><DIV><PRE>Regex Replace</PRE> </DIV><P>Evaluation Mode </P><DIV><PRE>Entire text</PRE></DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="78526-replacetext.png" style="width: 1339px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/14794i4B31BD898AEB30A5/image-size/medium?v=v2&amp;px=400" role="button" title="78526-replacetext.png" alt="78526-replacetext.png" /></span></P><P><STRONG><U>Input:-</U></STRONG></P><PRE>{ "soap:Envelope": { "soap:Body": { "Musteri_Hiyerarsi_TablosuResponse": { "Musteri_Hiyerarsi_TablosuResult": "[ { "UNIQ_KEY": 740281.0, "TTALT": 112.0, "TTAD": "TEST" } ]" } } } }</PRE><P><U>Output: </U>valid json</P><PRE>{ "soap:Envelope": { "soap:Body": { "Musteri_Hiyerarsi_TablosuResponse": { "Musteri_Hiyerarsi_TablosuResult": [ { "UNIQ_KEY": 740281.0, "TTALT": 112.0, "TTAD": "TEST" } ] } } } }</PRE> Sun, 18 Aug 2019 00:20:34 GMT Shu_ashu 2019-08-18T00:20:34Z