1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
|
import sys
import os
import csv
argument1 = sys.argv[0]
passage = 0
codeetbs = ""
libetbs = ""
finess = ""
codeuf = ""
libuf= ""
dateuf1 = ""
dateuf2 = ""
activite = ""
indicateurT2A = ""
budget = ""
analyse = ""
ca = ""
libca = ""
codecr = ""
libcr = ""
codepole = ""
dic_ca = dict()
dic_cr = dict()
print ("argument1 = " ,argument1)
c = csv.writer(open("C:/python/fichier/structcsv.csv", "wb"))
f=open("C:/python/fichier/struct5-Aubusson.txt", "r")
while 1:
data=f.readline()
if not data:
break
if data[2:4] == "UF":
codeuf = data[5:9]
libuf = data[167:202]
dateuf1 = data[32:34] + "/" + data[30:32] + "/" + data[26:30]
dateuf2 = data[40:42] + "/" + data[38:40] + "/" + data[34:38]
activite = "Service"
if data[319:320] == "1":
activite = "Service"
else:
activite = "Magasin"
budget = data[80:82]
analyse = data[114:124]
ca = data[124:128]
libca = dic_ca[ca + " "]
cr = data[106:110]
libcr = dic_cr[cr]
codepole = data[471:483]
indicateurT2A = data[483:495]
with open('C:/python/fichier/structcsv.csv', 'w', newline='') as csvfile:
spamwriter = csv.writer(csvfile, delimiter=';',
quotechar='|', quoting=csv.QUOTE_MINIMAL)
if passage == 1:
spamwriter.writerow((codeetbs,libetbs,finess,codeuf,libuf,dateuf1,dateuf2,activite,indicateurT2A,budget,analyse,ca,libca,cr,libcr,codepole))
else:
spamwriter.writerow(('CODEETBS','LIBETBS','FINESS','CODEUF','LIBUF','DATEUF1','DATEUF2','ACTIVITE','INDICATEURT2A','BUDGET','ANALYSE','CA','LIBCA','CODECR','LIBCR','CODEPOLE'))
spamwriter.writerow((codeetbs,libetbs,finess,codeuf,libuf,dateuf1,dateuf2,activite,indicateurT2A,budget,analyse,ca,libca,cr,libcr,codepole))
passage = 1
if data[2:4] == "CA":
dic_ca[data[5:11]] = data[100 : 135]
if data[2:4] == "CR":
dic_cr[data[5:9]] = data[92 : 127]
if data[2:4] == "EJ":
if codeetbs == "":
codeetbs = data[5 : 7]
libetbs = data[175 : 210]
finess = data[166 : 175]
os.system("pause") |
Partager