Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

REGEX expression to remove extra lines/ backspaces in csv file in Apache nifi

REGEX expression to remove extra lines/ backspaces in csv file in Apache nifi

Explorer

I had a csv file with some faulty values , i have used replace text and some appropriate regex expression to overcome these faulty values.

But still i am getting an error indicating that i have an abnormal value in one of my columns, but i have gone through each line of the csv file and i cant find anything wrong, leading me to believe that my replace text processor must have included some extra whitespaces in the csv file.

 

I am not sure that it is only whitespaces, it could be something else also. The csv files contains 1000's of lines and it looks similar to the non-faulty csv files in terms of data. So i am at wits end here, any kind of help would be appreciated. 

Don't have an account?
Coming from Hortonworks? Activate your account here