On 02/28/2013 02:14 PM, io wrote:
Hi,

i have to files.

First file is a csv file
Second file is a plain text file where each row has a value (text)

I want to be able to create a third file using data from the first file
excluding the values listed in the second file.

Example:

First file:
-----------

mtgoxeur        12      24      36
mtgoxusd        10      12      14
mtgoxpln        2       4       6


Second file:
------------

mtgoxusd



Third File (the resulting one) :
--------------------------------

mtgoxeur        12      24      36
mtgoxpln        2       4       6



Thanks to anyone that can help




Start by making a set out of the second file. Don't forget to remove whitespace with strip()

Then loop through the first file. For each line, split() it by whitespace, and conditionally write the line to the third file. The test would be something like:
     if  fields[0] in myset:
           outfile.write(line)


--
DaveA
--
http://mail.python.org/mailman/listinfo/python-list

Reply via email to