| 1 |
nino.borges |
475 |
|
| 2 |
|
|
==== Here I was asked to both test the kpmg enumerated values field and to also verify that
|
| 3 |
|
|
all of the bendix ranges in rl were in my LFP.
|
| 4 |
|
|
-------------------------------
|
| 5 |
|
|
>>> contents = open(r"\\bstads01\app\Manny\Client\honeywell\LFP Export\LFP Export\Non_microfiche\373540873_REVIEW_JUSTBENDIX.lfp").readlines()
|
| 6 |
|
|
>>> MasterList = []
|
| 7 |
|
|
>>> for line in contents:
|
| 8 |
|
|
... bates = line.split(",")[1]
|
| 9 |
|
|
... MasterList.append(bates)
|
| 10 |
|
|
...
|
| 11 |
|
|
>>> len(MasterList)
|
| 12 |
|
|
357525
|
| 13 |
|
|
|
| 14 |
|
|
-------------------------------
|
| 15 |
|
|
>>> outputFile2 = open(r"C:\Client\honeywell\BENDIX-Beg_End_Enum_enumErr.csv",'w')
|
| 16 |
|
|
>>> outputFile = open(r"C:\Client\honeywell\BENDIX-Beg_End_Enum_output.csv",'w')
|
| 17 |
|
|
>>> for line in contents:
|
| 18 |
|
|
... line = line.replace("\n","")
|
| 19 |
|
|
... begNo,endNo,enumValues = line.split(",")
|
| 20 |
|
|
... begTest = begNo.split(" ")[-1]
|
| 21 |
|
|
... endTest = endNo.split(" ")[-1]
|
| 22 |
|
|
... rangeTest = FixBatesRange_func.EnumerateBates(begTest,endTest)
|
| 23 |
|
|
... enumCount = len(rangeTest)
|
| 24 |
|
|
... if ";" in enumValues:
|
| 25 |
|
|
... kpmgEnumCount = len(enumValues.split(";"))
|
| 26 |
|
|
... else:
|
| 27 |
|
|
... kpmgEnumCount = 1
|
| 28 |
|
|
... if enumCount == kpmgEnumCount:
|
| 29 |
|
|
... pass
|
| 30 |
|
|
... else:
|
| 31 |
|
|
... outputFile2.write(line+"\n")
|
| 32 |
|
|
... if begNo in MasterList:
|
| 33 |
|
|
... pass
|
| 34 |
|
|
... elif begNo.replace(" "," ") in MasterList:
|
| 35 |
|
|
... pass
|
| 36 |
|
|
... elif begNo.replace(" "," ") in MasterList:
|
| 37 |
|
|
... pass
|
| 38 |
|
|
... elif begNo.replace(" "," ") in MasterList:
|
| 39 |
|
|
... pass
|
| 40 |
|
|
... elif begNo.replace(" ","") in MasterList:
|
| 41 |
|
|
... pass
|
| 42 |
|
|
... elif begNo.replace(" ","") in MasterList:
|
| 43 |
|
|
... pass
|
| 44 |
|
|
... else:
|
| 45 |
|
|
... outputFile.write(line+"\n")
|
| 46 |
|
|
...
|
| 47 |
|
|
>>> outputFile.close()
|
| 48 |
|
|
>>> outputFile2.close() |
