NIFI - ReplaceText crashs my csv file

2 replies
2544 views
Translate All

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 :

Apache NiFi

SAMSALAnswer

Platinum ⭐️⭐️⭐️

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

SAMSALAnswer

Platinum ⭐️⭐️⭐️

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

Translate

FediMannoubiAuthor

Gold ⭐️

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

Translate

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.