CSV Datei leer Zellen löschen

M

madmax04101

Neues Mitglied
Thread Starter
Dabei seit
23.12.2018
Beiträge
12
Reaktionspunkte
0
Hallo!

Ich würde gerne mit dem Automator eine CSV Datei automatisch bearbeiten.

Bei der CSV Daten sollen alle Zellen die leer sind gelöscht werden.

Wie gehe ich da am besten vor?
 
Definiere leer.
Sind die ‘null’?
Oder nur die Trennzeichen drin?
Oder einfach nur returns?
 
  • Gefällt mir
Reaktionen: dg2rbf
ja Leer
Bildschirmfoto 2019-01-13 um 11.49.59.png
 
Wie sieht es denn in der csv aus?
Excel und co. Sind da oft sehr “eigenwillig’ in der Darstellung.
Csv mal mit einem Texteditor öffnen und auch Sonderzeichen anzeigen lassen.
 
CSV hat keine Zellen, also schau doch mal mit einem Texteditor in der CSV wie die überhaupt formatiert ist.
 
"LRP133184","","","133184","4250068152074",",02462500000000000244","2,95","2,4583333333333333","",",01","LRP","","","LRP-Rest","","0","","41436 LRP","2,43370833333333333056","","","","","1","","LRP Spurstange Lenkservo Rebel BX Bxe","","","","","","","133184","","","LRP Ersatzteile f¸r Autos","","","","","","","","","","182202","","119,79","","RW3212,AM199110,RC4ZS0812,RC4ZRTR0030,ASC9588,KYO34201EU-BG,GR-9944.834,HUD293561-O,RC4VVVC0304,NOVA-11016,GR-90173.6,XRA305184,","","","4.1666666666666667","1","","","","Ja","","","","","","","","#AUS#","","","","","","","","","#TEXTM","#TEXTO","LRP","2,74","82321","70015","1","1","ZL","1","1,1","0",",02462500000000000244","0","","","","","","","","","","","","","","","","","","","","","","","","","","","","Ja","","","LRP133184","","","Ausgelaufen","","Import vom 04.03.2016 18:59:41 Uhr","","Brutto","0",",02462500000000000244","0","2,95","2,95","","99","","","1","93",",76704166666666666456","","","Nein","","","Ja","","","Ja","","",",95",",95",",7916666666666667","Ja","","",""
"LRP133184_10","","","LRP133184_10","","0","29,95","24,9583333333333333","","0","LRP","","","","","0","","41436 LRP","24,9583333333333333","","","","","1","","LRP Spurstange Lenkservo Rebel BX Bxe 10 PACK","","","","","","","133184_10","","","LRP Ersatzteile f¸r Autos","","","","","","","","","","182202","","1,6","","AB-1230368,GR-3935.11.25,GR-1882.12,KYOIS154,KYOMDW018-02,XRA302615,GR-95168,ASC31139,R20003L,RC4ZX0046,GR-90158.14,HPI116020,","","","7.4166666666666667","4,9","","","","Ja","","","","","","","","","","","","","","","","","","","LRP","","138226","70015","0","1","ZL","1","1","0","0","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Ja","","","LRP133184_10","","","Ausgelaufen","","Import vom 16.07.2018 22:04:34 Uhr","","Brutto","0","0","0","29,95","","","99","","","1","9","4,125","","","Nein","","","Ja","","","Ja","","","4,95","4,95","4,125","Ja","","",""
"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",,,,,,,,,,,,,,,,,,,,,"","","","","","","","","","","","","LRP","","138226","70015","0","1","ZL","1","1","0","0","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
 
Wow, ist die Übel formatiert.

Aber es sind auf den ersten Blick keine leeren Zeilen drin.
Ist sehr wahrscheinlich ein darstellungsproblem des von dir gewählten Tools (Excel?)
 
terminal:
Code: 
sed '/^;;;;;;;;;;.*/d' file.csv > newfile.csv
 
Du musst dich einloggen oder registrieren, um hier zu antworten.
Zurück
Oben Unten