how to separate email after fetching from database

Question

Hi i am fetching email to list from database which is like below

'XXXXXXXX@gmail.com,XXXXXXXX@gmail.com,XXXXXXXX@gmail.com'

i want to separate these mail like

 'XXXXXXXX@gmail.com','XXXXXXXX@gmail.com','XXXXXXXX@gmail.com'

in python function so can pass it in msg["To"] field.

`email_list_string.split(',')` – shad0w_wa1k3r Feb 10 '18 at 14:27 — shad0w_wa1k3r, Feb 10 '18 at 14:27

score 0 · Answer 1 · answered Feb 10 '18 at 14:29

0

You can use split function with delimeter as ,:

email_string = 'XXXXXXXX@gmail.com,XXXXXXXX@gmail.com,XXXXXXXX@gmail.com'
email_list = email_string.split(",")

answered Feb 10 '18 at 14:29

Kapil

but when i am passing this "email_list" variable , it shows error – Rahul Gour Feb 10 '18 at 14:33
Can you provide more details like where are using/passing the "email_list" variable and what error are you getting? – Kapil Feb 10 '18 at 14:35

score 0 · Answer 2 · answered Feb 10 '18 at 14:29

0

Use str.split like so

'XXXXXXXX@gmail.com,XXXXXXXX@gmail.com,XXXXXXXX@gmail.com'.split(',')

outputs:

 ['XXXXXXXX@gmail.com', 'XXXXXXXX@gmail.com', 'XXXXXXXX@gmail.com']

answered Feb 10 '18 at 14:29

FHTMitchell

Martin Evans · Answer 3 · 2018-02-10T14:53:24.913

0

The msg["To"] parameter normally takes addresses separated by comma and a space so the following should be what you need:

email_string = 'XXXXXXXX@gmail.com,XXXXXXXX@gmail.com,XXXXXXXX@gmail.com'
msg["To"] = ', '.join(email_string.split(',')

This would pass the following single string:

XXXXXXXX@gmail.com, XXXXXXXX@gmail.com, XXXXXXXX@gmail.com

or alternatively, you could use a replace to add a space:

msg["To"] = email_string.replace(',', ', ')

If you want your string to have quotes around each email address:

email_string = "'{}'".format("','".join(email_string.split(',')))

Giving you a string looking like:

'XXXXXXXX@gmail.com','XXXXXXXX@gmail.com','XXXXXXXX@gmail.com'

edited Feb 10 '18 at 14:53

answered Feb 10 '18 at 14:36

Martin Evans

`msg["To"]` does not need space after comma. "XXXXXXXX@gmail.com,XXXXXXXX@gmail.com,XXXXXXXX@gmail.com" would also work. – Kapil Feb 10 '18 at 14:51
Correct, but most examples add the space for clarity. – Martin Evans Feb 10 '18 at 14:57

3 Answers3