Support Questions
Find answers, ask questions, and share your expertise

Partition record processor on csv data error. Invalid char between encapsulated token and delimiter

Explorer

I am getting csv files after hitting an api (using invokeHTTP), after that i pass it to a Partition record Processor whose configuration is shown below:Partition Record processorPartition Record processor

 

But i am getting this error :Screenshot (8).png

Line 81 seems to be the problem. Below are the lines 80 (which is not giving the error) and line 81 (which is giving the error):

LINE 80: "12823279995108993","12823279995125025","","BUS_IN","2020-10-17 04:46:39","2020-10-17 11:20:00","ONWARD","BS:MOBILEWEB#droidapp",2,"S18\:S17","TENTATIVE_EXPIRED","","","",false,"",false,"","","abc","MALE",21,43860744,91987654321,"abc@gmail.com","","19023","Expresso","46","14118149","A/C Seater / Sleeper (2+2)","Delhi","733","20328326","01204760001","2020-10-17 14:00:00","2020-10-17 11:20:00","1377","Kanpur (Uttar Pradesh)","20673108","2020-10-17 22:00:00","2020-10-17 22:00:00",0,false,1236.90,1178.00,0.00,0.00,1011.19,1236.90,0,"","",0,58.90,0.00,"911edfa4b1d6f0055722993401020100","INR",1178.00,"INR","0:12:100:0;12:24:50:0;24:-1:20:0","INR","","",0,"",1,"",0,"",0,"4:-1:10:0"


LINE 81: "12823279989247850","12823279989257690","","BUS_IN","2020-10-17 04:46:38","2020-10-17 09:30:00","ONWARD","BS:MOBILEWEB#droidapp",1,"L4","TENTATIVE_EXPIRED","","","",false,"",false,"","","bcd","FEMALE",22,44156809,91123456789,"bcd@gmail.com","","18599","abc travels and Cargo","106123","15476131","A/C Seater / Sleeper (2+1)","Surat","473","21765854","9799678467\","2020-10-17 09:30:00","2020-10-17 09:30:00","78027","Gorakhpur (uttar pradesh)","19252221","2020-10-19 00:49:00","2020-10-19 00:49:00",0,false,2650.00,2500.00,0.00,0.00,2146.00,2650.00,0,"","",0,125.00,0.00,"9113aebbb1d6f005e2483f9f02020100","INR",2500.00,"INR","0:24:100:0;24:48:70:0;48:72:50:0;72:166:40:0;166:-1:30:0","INR","","",0,"",0,"",0,"",0,""

 

I am not allowed to change the schema or fields in any way from the api side, so i have to add some processor in Nifi to overcome this error. 

Thanks in advance