'Nifi: Delimiters in Nifi

I was working on a task and got an error. Which says that invalid char between encapsulated token and delimiter. Here is the SS of the data

enter image description here

For line 08, I was using the pipe as a delimiter, and the escape character was '^'. For line 12 I was using the comma as a delimiter. The highlighted part is the issue. If I remove the cap sign from line 08 and a single quote from line 12 it runs with success. The processor is ConverRecord and here is the screenshot of the configs of the processor.

enter image description here

Actually, I am using two processors of ConvertRecord. In one processor the fields separator is a comma(,) whereas in the second processor the fields separator is also comma(,) but the escape character is Cap sign(^).

assume that these are two different records.
Why it is throwing error at that point? And how can I solve this issue?

Thanks in advance.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source