Ciao a tutti.. ho dei seri problemi con la creazione di un batch che faccia quello che mi serve..
In pratica io dovrei trasformare questo file txt
ME00000018036ACQUA FRIZZ. PET 500ML MONTER 1 0500 050000120343200010PZ 0006596312000000000022F 00018000060000000290M 8004192900058000000000000000000348000000000 B00305220170117 00000000000000002200 000001200000000000022387*
NS00000025125PETTO POLLO FETTE 350GR SANBAR 1 0350 035000000250500030KG 0006597216000000000010F 00100000050000021910 000000000000000001516000000000 B00305220170117 00000000000000001000 000000069000000000022387*
ME00000002049ACQUA NATUR. PET 1,5LT LAURET 1 1500 150000060343200010PZ 0006596312000000000022F 00021000040000000450M 8004192202107000000000000000000810000000000 B00305220170117 00000000000000002200 000001800000000000022387*
NS00000021050ARANCE TAROCCO TAVOLA 1 0000 000000070110300064KG 0006597215000000000004F 00008000050000001700 000000000000000001190000000000 B00305220170117 00000000000000000400 000000700000000000022387*
In un file cosi formattato:
la mia problematica maggiore è che devo insrire una , quando nel prodotto c'è l'unita di misura KG e quindi la , deve essere inserita 2 numeri prima della scritta KG mentre quando c'è scritto PZ non deve cambiare nulla..ME00000;018036;ACQUA FRIZZ. PET 500ML MONTER; 1; 0500; 0500001203432;00010;PZ; 0006596312000000000022F 00018000060000000290M ; ;8004192900058;000000000000000;000348000000000 B0030;5220170117 00000000000000002200; ; 00;000120;00000;00000022387*
NS00000;025125;PETTO POLLO FETTE 350GR SANBAR; 1; 0350; 0350000002505;00030;KG; 0006597216000000000010F 00100000050000021910 ; ; ;000000000000000;001516000000000 B0030;5220170117 00000000000000001000; ; 00;000006;90000;00000022387*
ME00000;002049;ACQUA NATUR. PET 1,5LT LAURET; 1; 1500; 1500000603432;00010;PZ; 0006596312000000000022F 00021000040000000450M ; ;8004192202107;000000000000000;000810000000000 B0030;5220170117 00000000000000002200; ; 00;000180;00000;00000022387*
NS00000;021050;ARANCE TAROCCO TAVOLA ; 1; 0000; 0000000701103;00064;KG; 0006597215000000000004F 00008000050000001700 ; ; ;000000000000000;001190000000000 B0030;5220170117 00000000000000000400; ; 00;000070;00000;00000022387*
spero di essermi spiegato bene
Rigrazio in anticipo