Sorry me for bad english.
i have this txt file and i read lineby line with the tipical freefile=file, ecc:
...
code subcode euro
Z45 A 67,90
Z45 B 1,89
Z47 B 10,00
...
I get the value of cod, subcode and euro with a mid function and assign to:
varcod
varsubcode
vareuro
i need with a Dictionary object (or other way) based nthe join of code&subcode summ of euro, example:
line of txt
varcod&subcode not exists, assign to the key of Dictionary, Z45A, 67,90
second line of txt
varcod&subcode not exists, assign to the key of Dictionary, Z45B, 1,89
3thline ne of txt
varcod&subcode just exists, sum 10 to alread combination of the key of Dictionary, Z45B, 1,89
....
ecc
final result to the end of loop txt:
Z45A, 67,90
Z45B, 11,89
i hope to be clear
note:
before to the end of code, post a simple code to loop the DictionARY, with a for next
i have this txt file and i read lineby line with the tipical freefile=file, ecc:
...
code subcode euro
Z45 A 67,90
Z45 B 1,89
Z47 B 10,00
...
I get the value of cod, subcode and euro with a mid function and assign to:
varcod
varsubcode
vareuro
i need with a Dictionary object (or other way) based nthe join of code&subcode summ of euro, example:
line of txt
varcod&subcode not exists, assign to the key of Dictionary, Z45A, 67,90
second line of txt
varcod&subcode not exists, assign to the key of Dictionary, Z45B, 1,89
3thline ne of txt
varcod&subcode just exists, sum 10 to alread combination of the key of Dictionary, Z45B, 1,89
....
ecc
final result to the end of loop txt:
Z45A, 67,90
Z45B, 11,89
i hope to be clear
note:
before to the end of code, post a simple code to loop the DictionARY, with a for next