Reason: a line break in a string leads to a line break in to_csv() as well. This results in part on the line is written to the next row in the CSV file.
Example 1: The column "Aktenzeichen" in table permit of wind unit SME924935261407 has a line break at the end.
Example 2: The column "Aktenzeichen" in table permit of wind unit SME945284640484 has 4 line breaks.
Try to remove newline statements from Aktenzeichen string during CSV export. In the easiest case, this can be achieved with replace("\n", " ").
Reason: a line break in a string leads to a line break in
to_csv()as well. This results in part on the line is written to the next row in the CSV file.Example 1: The column "Aktenzeichen" in table permit of wind unit SME924935261407 has a line break at the end.
Example 2: The column "Aktenzeichen" in table permit of wind unit SME945284640484 has 4 line breaks.
Try to remove newline statements from Aktenzeichen string during CSV export. In the easiest case, this can be achieved with
replace("\n", " ").