> I was wondering if anyone here on the group could point me > in a direction that would expllaing how to use python to > convert a tsv file to html. I have been searching for a > resource but have only seen information on dealing with > converting csv to tsv. Specifically I want to take the > values and insert them into an html table. > > I have been trying to figure it out myself, and in > essence, this is what I have come up with. Am I on the > right track? I really have the feeling that I am > re-inventing the wheel here. > > 1) in the code define a css > 2) use a regex to extract the info between tabs > 3) wrap the values in the appropriate tags and insert into > table. > 4) write the .html file
Sounds like you just want to do something like print "<table>" for line in file("in.tsv"): print "<tr>" items = line.split("\t") for item in items: print "<td>%s</td>" % item print "</tr>" print "</table>" It gets a little more complex if you need to clean each item for HTML entities/scripts/etc...but that's usually just a function that you'd wrap around the item: print "<td>%s</td>" % escapeEntity(item) using whatever "escapeEntity" function you have on hand. E.g. from xml.sax.saxutils import escape : : print "<td>%s</td>" % escape(item) It doesn't gracefully attempt to define headers using <thead>, <tbody>, and <th> sorts of rows, but a little toying should solve that. -tim -- http://mail.python.org/mailman/listinfo/python-list