question Re: Nifi Repalce text - double quotes to single quotes in Support Questions

Nifi Repalce text - double quotes to single quotes

av_venkatesh86 — Wed, 06 Feb 2019 01:46:56 GMT

Assistance required to replace double quotes with single quotes in Nifi Replace Text processor, Please assist.

Input: "162","298","99","1.5","3","7.46","0","0.53","1"

Output: '162','98','99','1.5','3','7.46','0','0.53','1'

Post 'Replace Text' i will pass on the values to Putsql processor which inserts data into Oracle, where double quotes for column value is not accepted.

Re: Nifi Repalce text - double quotes to single quotes

MattWho — Sat, 17 Aug 2019 21:38:32 GMT

@Venkatesh AV

Just want to make sure we are using correct processor for what you want to do:

The ReplaceText processor is used to replaceText in the content of the FlowFile.
The UpdateAttribute processor could be used to replace text contained within an attribute of a FlowFile.

Assuming the FlowFile content is where you want to replace double quote with single quote, the following ReplaceText processor configuration will do that for you:

Thank you,

Matt

If you found this answer addressed your question, please take a moment to login in and click the "ACCEPT" link.

Re: Nifi Repalce text - double quotes to single quotes

av_venkatesh86 — Sat, 17 Aug 2019 21:38:25 GMT

Thanks for your response Matt.

It is working now with updateattribute processor as it's attribute level. Thumbs up to you