I have a CSV file, generate by ERP, the delimiter is pipe (|). But in this file I have columns with the format in ERP is Text and the users in many lines put pipe(|) in the middle of the text ex |100019391 |99806354 |EV | RES: Consulta COBRO VVISTA - Chile |31|24.06.2021|
this part EV | Res*** is the field where de user put pipe.
My error is, when the pand read this lines, it give me a Error
Skipping line 46: Expected 28 fields in line 46, saw 29
CodePudding user response：
Tks for the answer
Unfortunately I have lines in the CSV file where doesn't have nothing inside the pipe and some cases I`ve space before the pipe
|Customer |Reference |Due date | |374696 | |16.01.2019| |390531 |002 |11.02.2017|
Ex. in the first line the field reference is empty
thanks