https://community.cloudera.com/t5/Support-Questions/ReplaceText-Processor-not-processing-all-Expresssion/m-p/189291#M151384 <P><A rel="user" href="https://community.cloudera.com/users/70448/xlammertink.html" nodeid="70448" target="_blank">@Xander L</A></P><P><STRONG><U>Method1:-</U></STRONG></P><P>You can add new extract text processor before replace text processor and keep the whole content of the flowfile as attribute and use the extracted attribute in Replace Text processor to get escapeJson function.</P><P><STRONG><U>Extract text Processor Configs:-</U></STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="65391-extracttext.png" style="width: 1865px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18567iC2A8294C3DA7E6F5/image-size/medium?v=v2&amp;px=400" role="button" title="65391-extracttext.png" alt="65391-extracttext.png" /></span></P><P>Add new property by clicking on + sign at top right corner</P><P>in my case i have added extract property with below regex</P><P><STRONG>extract </STRONG></P><PRE>(.*)</PRE><P>Now we are going to extract all the content of the flowfile and keep that content as extract attribute to the flowfile.</P><P>You need to increase the below properties sizes if you are having big content to extract</P><P>Maximum Buffer Size</P><DIV><PRE>1 MB</PRE> </DIV><P>Maximum Capture Group Length</P><DIV><PRE>1024</PRE></DIV><P><STRONG><U>Output from extract text processor:-</U></STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="65393-output-extracttext.png" style="width: 1770px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18568iBFF91C809BD7F316/image-size/medium?v=v2&amp;px=400" role="button" title="65393-output-extracttext.png" alt="65393-output-extracttext.png" /></span></P><P><STRONG><U>Replace text Configs:-</U></STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="65392-replacetext.png" style="width: 1652px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18569i1B6111FBA46FF2C8/image-size/medium?v=v2&amp;px=400" role="button" title="65392-replacetext.png" alt="65392-replacetext.png" /></span></P><P>Change the configs according to the screenshot,</P><P>Search Value</P><DIV><PRE>(?s)(^.*$)</PRE> </DIV><P>Replacement Value</P><DIV><PRE>${extract:escapeJson()}</PRE> </DIV><P>Character Set</P><DIV><PRE>UTF-8</PRE> </DIV><P>Maximum Buffer Size</P><DIV><PRE>1 MB //needs to change if the size of flowfile is more than 1 MB</PRE> </DIV><P>Replacement Strategy</P><DIV><PRE>Always Replace</PRE> </DIV><P>Evaluation Mode</P><DIV><PRE>Entire text</PRE></DIV><P>Now we are applying escapeJson function to the extract attribute as a replacement value.</P><P><STRONG><U>Output:-</U></STRONG></P><PRE>https 2018-03-18T23:55:36.990541Z app\/abc-pxx-p001\/abc123 12.34.56.78:12345 87.65.43.21:80 0.000 0.092 0.000 200 200 1124 364 \"GET https:\/\/mysite.nl:443\/test HTTP\/1.1\" \"abc\/1 CFN\/987 Darwin\/12.3.4\" ECDHE-RSA-AES128-GCM-SHA256 TLSv1.2 arn:aws:elasticloadbalancing:eu-west-1:012345679:targetgroup\/abc-external-abc-de\/abc123def456 \"Root=1-5a-d2a18df071c\" \"mysite.nl\" \"session-reused\" 0</PRE><P>(or)</P><P><STRONG><U>Method2:-</U></STRONG></P><P>By using two Replace text processor in series we can have same expected result instead of using extract text processor.</P><P><STRONG><U>Replace / with \/:-</U></STRONG></P><P>Search Value</P><DIV><PRE>/</PRE></DIV><P>Replacement Value</P><DIV><PRE>\/</PRE></DIV><P>Character Set</P><DIV><PRE>UTF-8</PRE></DIV><P>Maximum Buffer Size</P><DIV><PRE>1 MB</PRE></DIV><P>Replacement Strategy</P><DIV><PRE>Literal 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="65394-replacetext-1.png" style="width: 1546px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18570i2154CB18CBAD1264/image-size/medium?v=v2&amp;px=400" role="button" title="65394-replacetext-1.png" alt="65394-replacetext-1.png" /></span></P><P>in this processor we are searching for / <STRONG>literal</STRONG> and replacing / with \/.</P><P>feed the<STRONG> success</STRONG> relation from this <STRONG>replacetext processor to the next replace text processor</STRONG></P><P><STRONG><U>Replace text processor 2 for replace " with \":-</U></STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="65395-replacetext-2.png" style="width: 1535px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18571i1782BAAAEE824E94/image-size/medium?v=v2&amp;px=400" role="button" title="65395-replacetext-2.png" alt="65395-replacetext-2.png" /></span></P><P>Search Value</P><DIV><PRE>"</PRE></DIV><P>Replacement Value</P><DIV><PRE>\"</PRE></DIV><P>Character Set</P><DIV><PRE>UTF-8</PRE></DIV><P>Maximum Buffer Size</P><DIV><PRE>1 MB</PRE></DIV><P>Replacement Strategy</P><DIV><PRE>Literal Replace</PRE></DIV><P>Evaluation Mode</P><DIV><PRE>Entire text</PRE> </DIV><P>In the next replace text processor we are searching for " and replacing " with \" by using literal replace as Replacement strategy.</P><P>Output flowfile content from second replace text processor will be same as our method 1.</P><PRE>https 2018-03-18T23:55:36.990541Z app\/abc-pxx-p001\/abc123 12.34.56.78:12345 87.65.43.21:80 0.000 0.092 0.000 200 200 1124 364 \"GET https:\/\/mysite.nl:443\/test HTTP\/1.1\" \"abc\/1 CFN\/987 Darwin\/12.3.4\" ECDHE-RSA-AES128-GCM-SHA256 TLSv1.2 arn:aws:elasticloadbalancing:eu-west-1:012345679:targetgroup\/abc-external-abc-de\/abc123def456 \"Root=1-5a-d2a18df071c\" \"mysite.nl\" \"session-reused\" 0</PRE><P>Both ways we are getting same expected result, choose the way which can better fit for your case.</P><P>Let us know if you are having any issues..!!</P><P>.</P><P>If the Answer helped to resolve your issue, <STRONG>Click on Accept button below to accept the answer,</STRONG> That would be great help to Community users to find solution quickly for these kind of issues.</P> Sun, 18 Aug 2019 07:44:35 GMT Shu_ashu 2019-08-18T07:44:35Z