| 1 |
|
| 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() |
