HI: I am trying to read a txt file and dump the columns in an access database table. But getting problem:
>>> Unhandled exception while debugging... Traceback (most recent call last): File "C:\WindDuration\Reading_test.py", line 14, in <module> my_length_1 = nmAddrList[1] IndexError: list index out of range Getting error when it is reading to second line. The txt file is attached here and I need only 2,8,11,14,15 columns to dump in the table. Any help is highly appreciated. Thanks sa We value your opinion. Please take a few minutes to share your comments on the service you received from the District by clicking on this link<http://my.sfwmd.gov/portal/page/portal/pg_grp_surveysystem/survey%20ext?pid=1653>.
FL Dade Existing Existing Existing 10/24 12E [05] 10/24 14E [07] 10/24 16E [09] 88kt 10/24 07 FL Monroe Existing Existing Existing 10/24 11E [04] 10/24 12E [05] 10/24 15E [08] 94kt 10/24 07 FL Collier Existing Existing Existing 10/24 12E [05] 10/24 13E [06] 10/24 15E [08] 104kt 10/24 0 FL Broward Existing Existing Existing 10/24 13E [06] 10/24 14E [07] 10/24 16E [09] 93kt 10/24 08 FL Lee Existing Existing Existing 10/24 10E [03] 10/24 12E [05] 10/24 15E [08] 89kt 10/24 07 FL Hendry Existing Existing Existing 10/24 12E [05] 10/24 14E [07] 10/24 16E [09] 100kt 10/24 0 FL Palm Beach Existing Existing Existing 10/24 14E [07] 10/24 15E [08] 10/24 17E [10] 93kt 10/24 08 FL Charlotte Existing Existing Existing 10/24 10E [03] 10/24 12E [05] 10/24 15E [08] 76kt 10/24 07 FL Glades Existing Existing Existing 10/24 12E [05] 10/24 14E [07] 10/24 16E [09] 91kt 10/24 09 FL Martin Existing Existing Existing 10/24 14E [07] 10/24 15E [08] 10/24 17E [10] 92kt 10/24 11 FL St Lucie Existing Existing 10/24 08E 10/24 14E [06] 10/24 15E [08] 10/24 17E [10] 89kt 10/24 11 FL Okeechobee Existing Existing Existing 10/24 13E [06] 10/24 15E [08] 10/24 17E [10] 83kt 10/24 09 FL Highlands Existing Existing Existing 10/24 12E [05] 10/24 14E [07] 10/24 16E [09] 74kt 10/24 09 FL Desoto Existing Existing Existing 10/24 09E [02] 10/24 12E [05] 10/24 15E [08] 67kt 10/24 08 FL Sarasota Existing Existing 10/24 11E [04] 10/24 15E [08] 59kt 10/24 07 FL Manatee Existing Existing 10/24 11E [04] 10/24 15E [08] 56kt 10/24 07 FL Hardee Existing Existing 10/24 12E [05] 10/24 16E [09] 60kt 10/24 08 FL Pinellas Existing 10/24 13E [06] 43kt 10/24 07 FL HillsborougExisting Existing 10/24 08E [01] 10/24 15E [08] 50kt 10/24 07 FL Polk Existing Existing 10/24 13E [06] 10/24 16E [09] 60kt 10/24 09 FL Osceola Existing Existing 10/24 10E 10/24 11E [01] 10/24 14E [07] 10/24 17E [10] 64kt 10/24 10 FL Indian RiveExisting Existing 10/24 09E 10/24 14E [05] 10/24 15E [08] 10/24 17E [10] 76kt 10/24 11 FL Brevard Existing Existing 10/24 10E 10/24 13E [03] 10/24 15E [08] 10/24 18E [11] 67kt 10/24 11 FL Orange Existing 10/24 09E 10/24 13E [04] 10/24 17E [10] 53kt 10/24 11 FL Seminole Existing 10/24 17E [10] 48kt 10/24 10 FL Lake Existing 10/24 16E [09] 46kt 10/24 09 FL Sumter Existing 10/24 15E [08] 43kt 10/24 08 FL Pasco Existing 10/24 15E [08] 43kt 10/24 08 FL Hernando Existing 10/24 15E [08] 40kt 10/24 08 FL Citrus Existing 10/24 13E [06] 37kt 10/24 10 FL Marion Existing 10/24 15E [08] 39kt 10/24 10 FL Volusia Existing 10/24 18E [11] 48kt 10/24 10 FL Flagler 10/24 08E 10/24 16E [08] 40kt 10/24 11 FL Putnam 10/24 09E 10/24 16E [07] 38kt 10/24 12 FL St Johns 10/24 11E 10/24 16E [05] 36kt 10/24 12 -------------------------------------------------------------------------------------------------------------- This list represents wind arrival and departure details for Local locations that are currently forecast to have Tropical Storm or greater winds during the next 72 hours. This information is quite specific and is subject to large forecast errors. You should NOT use these wind forecasts until just before landfall, and then only as a general indication of the expected wind patterns.
-- http://mail.python.org/mailman/listinfo/python-list