charlotte county

Download a large ascii file from the internet. Put it into Excel , and to make it more manageable in size , exclude some of it with given perameters and guidelines. I don't need all the information in the orginal ascii file, but you know how to cut some of the information I want out. There will be more work available later. ## Deliverables go to this site [login to view URL] -near the bottom of the page is something called **007 REAL ESTATE PROPERTY TAX ROLL -download the 2 files. One is a large flat text ascii file. The other is the Tax Roll Layout. I don't need all these fields. See below as to what I need and what I don't. The resulting information...after it has been reduced with the following guidelines is put in excel. Note..there will be 2 excel files as all the corps., llc's, inc's will be in a separate file. I don't have a very large hard drive (I have an older ibook) so if the files are very large I won't be able to open them. ** TAX ROLL LAYOUT TPESCROW RECORD LENGTH 2300 TAX-YEAR 4 yes ASSESSED-YEAR 4 yes but..any with a number higher than 60,000 I don't want. ACCT-NO 20 yes FOLIO-NO 11 yes ESCROW 6 yes LOAN-NO 15 No EX-TYPE 4 no STATUS 2 yes ASSESSED 11 yes EXEMPT 11 no TAXABLE 11 yes MILL-CODE 6 no OWNR-NO 7 yes OWNR-ADDR 30 OCCURS 7 TIMES. yes ZIP 10 yes LEGAL 45 OCCURS 7 TIMES. yes ACRES 9 yes INSTALLMENTS 1 no DISTRICT TABLE OCCURS 30 TIMES. no DIST-TYPE 1 no DIST-CODE 3 no DIST-EXEM 11 no DIST-TXBL 11 no DIST-TAX 10 no TOTAL-TAX 13 yes TOTAL-PAID 13 yes BALANCE 13 yes RECEIPT-NO 11 no DATE-PAID 6 yes PAID-BY PIC 30 no NOV-AMOUNT 13 no DELQ-TAXES OCCURS 10 TIMES. no DELQ-YEAR 4 no DELQ-TAX 13 no DELQ-FACE 13 no SITUS ADDRESS yes CITY 3 yes ST-NAME 22 any llc, inc, corp, company should be in a separate file ST-NO 8 any individuals in the other file...this will be the smaller file GEO-NUMBER 30 no FUTURE-USE 97 no FILLER 1 no