I have been trying to figure out how to go about this project and am stuck.
I have a txt file that I need to go thru remove a bunch of data and save to a xls file or csv file. The text file I am reading looks something like this.
BLD,UNIT,ID,TYPE,MOVE_IN,MOVE_OUT,ADDRESS,NAMES,LEASE_BEGINS,STATUS,SECURITY_ON_HAND,RECURRING_CHARGES,LEASE_TERM,EXPPECTED_MOVE_OUT,OccuCount,UnitSqFt,
"01","01A","4","2X2","07/18/08","","UPPER RIVERDALE ROAD SE","Murray, Frances","07/18/08","N",100.00,625.00,"12","","2","1200"
But quite a bit larger(about 320 rows). I only need some of the fields and would like to be able to format them to something like this:
BLD UNIT ID TYPE MOVE_IN MOVE_OUT ADDRESS NAMES
Any help would be much appreciated.
thanks,
Kyle