[EMAIL PROTECTED] a écrit : > I have a .plt file (which is a tab delimited ASCII file) and I want to > format it to get a .dbf with data in rows and columns, detele some > rows/columns and substitute decimal '.' with ','. All this using Python
Then you may want to have a look here: http://docs.python.org/lib/module-csv.html and here: http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/362715 > (I'm using Pythonwin). > > The .plt file looks like this: > > * ISCST3 (02035): Tersa > * MODELING OPTIONS USED: > * CONC URBAN ELEV DFAULT > > * PLOT FILE OF ANNUAL VALUES FOR SOURCE GROUP: ALL > * FOR A TOTAL OF 400 RECEPTORS. > * FORMAT: (3(1X,F13.5),1X,F8.2,2X,A6,2X,A8,2X,I8.8,2X,A8) > * X Y AVERAGE CONC ZELEV > * ___________ ___________ ___________ ______ > 430342.00000 4580537.00000 0.25426 19.28 > 430842.00000 4580537.00000 0.27233 14.72 > 431342.00000 4580537.00000 0.30566 2.84 > 431842.00000 4580537.00000 0.30379 0.21 > 432342.00000 4580537.00000 0.27413 1.13 > 432842.00000 4580537.00000 0.25462 0.00 > 433342.00000 4580537.00000 0.25114 0.00 > 433842.00000 4580537.00000 0.28779 0.00 > 434342.00000 4580537.00000 0.29707 0.00 > 434842.00000 4580537.00000 0.31067 0.00 > .... > > I recorded a macro in Excel with the whole process, but when trying to > translate it into Python I get syntax errors which I don't know how to > solve. > > This is my python code: > ## ------------------------------------------ > import win32com.client > excel = win32com.client.Dispatch("Excel.Application") > excel.Visible = 0 > workbook=excel.Workbooks.Open('D:\AN00GALL.plt') > excel.Columns("A:A").Select > excel.Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, _ > SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ > ReplaceFormat:=False Ok. Where is your attempt to "translate" to Python, exactly ? So far, except for the first 2 lines, it's vb code, not Python. Please start by learning Python, then start doing the translation - and then we'll be glad to help you. (snip vb code) > Any ideas on what am I doing wrong? Yes : trying to feed vb code to the Python interpreter. -- http://mail.python.org/mailman/listinfo/python-list
