This code that I wrote is supposed to read/write a pipe-delimited file line by line to a new file with some simple text manipulation. (It also adds two new columns) and publishes a "Status Update" ever 100,000 lines to keep me updated on how close it is to completion.
I previously posted this code on StackOverflow to get help with incrementing, and someone mentioned that it would be faster if I did not open the second text file, but being extremely new at Python, I do not understand how to do that without potentially breaking the code.
counter=1
for line in open(r"C:\Path\name.txt"):
spline = line.split("|")
if counter==1:
with open(r"C:\PATH\2019.txt",'a') as NewFile:
spline.insert(23,"Column A")
spline.insert(23,"Column B")
s="|"
newline=s.join(spline)
NewFile.write(newline)
elif counter > 1 and not spline[22]=="0.00":
spline.insert(23,"")
spline.insert(23,"")
gl=spline[0]
gl=gl.strip()
if gl[0]=="-": gl="000" + gl
gl=gl.upper()
spline[0]=gl
if gl[:3]=="000": spline[24]="Incorrect"
s="|"
newline=s.join(spline)
with open(r"C:\PATH\PythonWrittenData.txt",'a') as NewFile:
NewFile.write(newline)
counter+=1
if counter%100000==0: print("Status Update: \n", "{:,}".format(counter))