<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
I`m not reading and writing to the same file, I just changed the actual paths to directory.<br>
<br>
This is for a school assignment, and we haven`t been taught any of the stuff you`re talking about.  Although I appreciate your help, everything needs to stay as is and I just need to create the loop to get rid of the farmID from the end of the postal codes.<br>

<span class=""><font color="#888888">--<br>
<a href="https://mail.python.org/mailman/listinfo/python-list" target="_blank">https://mail.python.org/mailman/listinfo/python-list</a><br>
</font></span></blockquote></div><br></div><div class="gmail_extra">If you are allowed to use if/then this seems to work:</div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">inFile = "data"</div>
<div class="gmail_extra">outFile = "processed"</div><div class="gmail_extra">inHandler = open(inFile, 'r')</div><div class="gmail_extra">outHandler = open(outFile, 'w')</div><div class="gmail_extra">
for line in inHandler:</div><div class="gmail_extra">    if line.startswith("FarmID"):</div><div class="gmail_extra">        outHandler.write("FarmID\tAddress\tStreetNum\tStreetName\tSufType\tDir\tCity\tProvince\tPostalCode\n")</div>
<div class="gmail_extra">    else:</div><div class="gmail_extra">        line = line.replace(" ","\t", 1)</div><div class="gmail_extra">        line = line.replace(" Rd,","\tRd\t\t")</div>
<div class="gmail_extra">        line = line.replace(" Rd","\tRd\t")</div><div class="gmail_extra">        line = line.replace("Ave,","\tAve\t\t")</div><div class="gmail_extra">        line = line.replace("Ave ","\tAve\t\t")</div>
<div class="gmail_extra">        line = line.replace("St ","\tSt\t\t")</div><div class="gmail_extra">        line = line.replace("St,","\tSt\t\t")</div><div class="gmail_extra">        line = line.replace("Dr,","\tDr\t\t")</div>
<div class="gmail_extra">        line = line.replace("Lane,","\tLane\t\t")</div><div class="gmail_extra">        line = line.replace("Pky,","\tPky\t\t")</div><div class="gmail_extra">
        line = line.replace(" Sq,","\tSq\t\t")</div><div class="gmail_extra">        line = line.replace(" Pl,","\tPl\t\t")</div><div class="gmail_extra"><br></div><div class="gmail_extra">
        line = line.replace("\tE,","E\t")</div><div class="gmail_extra">        line = line.replace("\tN,","N\t")</div><div class="gmail_extra">        line = line.replace("\tS,","S\t")</div>
<div class="gmail_extra">        line = line.replace("\tW,","W\t")</div><div class="gmail_extra">        line = line.replace(",","\t")</div><div class="gmail_extra">        line = line.replace(" ON","ON\t")</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">        outHandler.write(line)</div><div class="gmail_extra">inHandler.close()</div></div></div>