Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

Who agreed with this solution

avatar
Master Mentor

@smartraman 

You can use a ReplaceText processor to remove these special characters from your json.
Using your example, I could produce yoru desired output using the following java regular expression:

 

(\\")|[\Q[\E]|[\Q]\E]

 

Source:

MattWho_2-1628865095458.png


My ReplaceText processor was configured as follows:

MattWho_0-1628864989816.png

 

result:

MattWho_1-1628865039271.png


If you found this response addressed your query, please take a moment to login and click on "Accept as Solution".

Thank you,

Matt

View solution in original post

Who agreed with this solution