Skip to content

CSV

Jump to bottom
Dennis Boldt edited this page May 27, 2020 · 1 revision

Fix broken CSV files

On specific versions, two semi colons are missed in the CSV file. This regex fixes this issue:

sed -E "s/(\;[0-9]+\.[0-9]{6})([0-9]+\.[0-9]{3})([0-9]+\.[0-9]+\;)/\1;\2;\3/" kaputt.csv >repariert.csv

Clone this wiki locally