<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>Data format question</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hello,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"> I am writing a filter program that reads a column of data, converts it and then writes it to another file. I was wondering how do you convert a column of data (for example multiply the column by a number or replace the letter A with a number) and how does one maintain a column format in the new output file? Also any suggested readings either on-line or books on text file handling in Python would be appreciated. I have read through some of the tutorials on python.org and read the python grimore. Thanks.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Ara</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Here is a part of the code for pulling out a column of data and then writing it to new file.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">inp = open("out.txt","r")</FONT>
<BR><FONT SIZE=2 FACE="Arial">outp = open("out2.txt","w")</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">for line in inp.readlines():</FONT>
<BR><FONT SIZE=2 FACE="Arial"> words = line.split() #thanks to orbitz for this line</FONT>
<BR><FONT SIZE=2 FACE="Arial"> if len(words) >= 1: </FONT>
<BR><FONT SIZE=2 FACE="Arial"> outp.write(words[0]) </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">"There is something to be learned from a rainstorm. When meeting with a sudden shower, you try not to get wet and run quickly along the road. But doing such things as passing under the eaves of houses, you still get wet. When you are resolved from the beginning, you will not be perplexed, though you still get the same soaking." - Yamamoto Tsunetomo</FONT></P>
</BODY>
</HTML>