python parse file

Question

I have a file with username and emails, in this format :

pete,[email protected]

I want to only keep the email, so i thought about using a regex like this :

import re,sys

Mailfile = sys.argv[1]

file = open(Mailfile, "r")

for MAIL in file.readlines():
   tmp = re.split("\n+", MAIL)
   m = re.match( ',(.+)', MAIL)
   m.group(0)

But then I don't know how to store the result in a file. I always get the last email address in the new file.

What would be the best way to store the results in a file ? Thanks!

Is IP supposed to be MAIL?

jadkik94
– jadkik94

2012-06-21 23:02:57 +00:00
Commented Jun 21, 2012 at 23:02 — jadkik94
– jadkik94, Commented Jun 21, 2012 at 23:02

Hugh Bothwell · Accepted Answer · 2012-06-22 00:02:53Z

8

import sys

infile, outfile = sys.argv[1], sys.argv[2]

with open(infile) as inf, open(outfile,"w") as outf:
    line_words = (line.split(',') for line in inf)
    outf.writelines(words[1].strip() + '\n' for words in line_words if len(words)>1)

edited Jun 22, 2012 at 0:02

answered Jun 21, 2012 at 23:36

Hugh Bothwell

57k9 gold badges91 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Kirk Strauser Over a year ago

And line.split() splits on...?

Hugh Bothwell Over a year ago

@Kirk Strauser: yep, fixed that.

Kirk Strauser Over a year ago

Why are you stripping words[1] and then adding \n back onto it? Side note: I completely agree with your approach. Just nitpicking for the sake of new users who might be wondering about these things. :-)

Hugh Bothwell Over a year ago

@Kirk Strauser: um... general paranoia? If he had any extraneous whitespace in his original file, now he won't.

the wolf Over a year ago

+1, but I would add (line.split(',') for line in inf if ',' in line) to avoid the error on blank lines for the non existing subscription on words[1]

miku · Accepted Answer · 2012-06-21 23:25:05Z

2

You could use the csv module (since your data looks comma-separated, at least in your example):

import sys
import csv
with open('mail_addresses.txt', 'w') as outfile:
    for row in csv.reader(open(sys.argv[1], 'rb')):
        outfile.write("%s\n" % row[1])

edited Jun 21, 2012 at 23:25

answered Jun 21, 2012 at 23:04

miku

189k47 gold badges314 silver badges317 bronze badges

Comments

Kirk Strauser · Accepted Answer · 2012-06-21 23:36:01Z

1

Try something like this:

import sys

Mailfile = sys.argv[1]
Outfile = sys.argv[2]

try:
    in_file = open(Mailfile, 'r')
    out_file = open(Outfile, 'a')

    for mail in in_file.readlines():
        address = mail.split(',')[1].strip()
        out_file.write(address+',') #if you want to use commas to seperate the files, else use something like \n to write a new line.
finally:
    in_file.close()
    out_file.close()

edited Jun 21, 2012 at 23:36

Kirk Strauser

31.1k5 gold badges53 silver badges69 bronze badges

answered Jun 21, 2012 at 23:14

Justin.Wood

7255 silver badges10 bronze badges

3 Comments

Kirk Strauser Over a year ago

1) address would be a list of values after the split, and 2) file.readlines retains the \n at the end of each line.

user1473508 Over a year ago

hum the code echo a : TypeError: can only concatenate list (not "str") to list on the address line

user1473508 Over a year ago

Hum, I was looking for this type of output in the file: [email protected]\n [email protected]\n [email protected]\n I don't need the coma !

Collectives™ on Stack Overflow

python parse file

3 Answers 3

5 Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related