NIFI - ReplaceText crashs my csv file

[#1]

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 :

[#2 · Accepted solution]

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-thou...

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

Thanks

[#3 · Accepted solution]

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-thou...

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

Thanks

[#4 · Accepted solution]

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