question NIFI - ReplaceText crashs my csv file in Support Questions

NIFI - ReplaceText crashs my csv file

FediMannoubi — Wed, 15 Jun 2022 10:00:08 GMT

Hi,

I am getting a csv without a header then adding a header with ReplaceText to it after the ReplaceText the header is added but the rest is crashed.

PS: This problem happen with this file only I tried the flow with other csv files and worked fine, can this be a csvReader problem or configuration on the encoding ?

Before :

The replace :

After :

Re: NIFI - ReplaceText crashs my csv file

SAMSAL — Wed, 15 Jun 2022 12:59:57 GMT

Hi,

It could be an encoding issue that I faced a while back. please check out this post:

https://community.cloudera.com/t5/Support-Questions/Illegal-Arg-Exception-when-parsing-CSV-file-though-the-split/td-p/300565

Try to change the character set to UTF-16 to see if that will work. Hope that helps.

Thanks

Re: NIFI - ReplaceText crashs my csv file

FediMannoubi — Wed, 15 Jun 2022 15:07:42 GMT

I used ConvertCharacterSet and changed the oncoding from UTF-16 to UTF-8 and that fixed for me Thanks