Guten Morgen zusammen
Ich habe 2 csv Dateien.
a: enthält Produkte. mit EAN Code, beschreibung, Preisen, etc
EANCode,Artikelnummer,Bezeichnung,Einheit,Gebinde,Preis,VKPreis,Hersteller,ArtikelIndex,Menge 30091948,698962,Drehpapier Organic H,50 Blatt,50,"0,4","0,69",ZPP,6986, 40173962,670781,Bayreuther Bio-Weiss,"0,5 ltr",20,"0,59","0,99",BBB,6698, 40218502,437051,"Früchte Müsli,60gr P",60 gr,20,"0,14",0,DEE,3218, 40803067,671016,"Pils Alkoholfrei,0,5","0,5 ltr",20,"0,59","0,89",ADO,6707, 40803074,671027,"Weizen,0,5ltr Flasch","0,5 ltr",20,"0,59","0,89",ADO,6708, 40803180,670634,"Glossner Bio-Gold,0,","0,5 ltr",16,"0,64","0,99",GLO,6690, 40803265,670667,Glossner Helles Hefe,"0,5 ltr",16,"0,64","0,99",GLO,6692, 40803272,670691,Glossner Alkoholfrei,"0,5 ltr",16,"0,62","0,99",GLO,6693, 40803296,670746,Glossner Weizen-Thal,"0,5 ltr",16,"0,64","0,99",GLO,6696, 40803333,670645,"Glossner Edelpils,0,","0,5 ltr",16,"0,64","0,99",GLO,6691, 40803487,670757,"Glossner Radler,0,5l","0,5 ltr",16,"0,64","0,99",GLO,6697, 40803975,671005,"Pils,0,5ltr Flasche ","0,5 ltr",20,"0,59","0,89",ADO,6706, 40843070,630729,Vollmilch Schokolade,"12,5 gr",40,"0,25","0,39",VVA,6008, 40843087,630731,Feine Bitter Schokol,"12,5 gr",40,"0,25","0,39",VVA,6009, 42027966,562601,"Leberwurst,160gr Gla",160 gr,6,"1,63","2,49",ÖKL,4701, 42027973,562645,"Gourmet Leberwurst,1",160 gr,6,"1,95","2,99",ÖKL,4705, 42027980,562634,"Zwiebelwurst,160gr G",160 gr,6,"1,63","2,49",ÖKL,4704, 42027997,562623,"Jagdwurst,160gr Glas",160 gr,6,"1,63","2,49",ÖKL,4703, 42028000,562612,"Mettwurst,160gr Glas",160 gr,6,"1,63","2,49",ÖKL,4702, 42031079,670803,Urtrunk-naturtrüb in,"0,5 ltr",16,"0,59","0,99",ROT,6699, 42033318,722766,Mineralwasser extras,"0,7 ltr",12,"0,27","0,49",OTO,7199, 42033325,722889,Mineralwasser medium,"0,7 ltr",12,"0,27","0,49",OTO,7206
b: enthält Inventur. Hier gibt es nur 3 Saplaten, EAN Code Name (leer) und Stückzahl
Menge;Name;Barcode 1;;4006544307007 2;;4016221028002 3;;4104420031661 1;;4058700621052 1;;4012346157306 5;;4021851616802 3;;4006040003113 28;;4014472277163 3;;4021269041654 5;;4021269041678
Nun möchte ich in Datei a die Menge aus Datei b in die Spalte des jeweiligen Produkts schreiben. Kann mir von Euch jemand einen Tipp geben, wie man das macht ?
Gruß und Danke