how to separate email after fetching from database

Question

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

'[email protected],[email protected],[email protected]'

i want to separate these mail like

 '[email protected]','[email protected]','[email protected]'

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 = '[email protected],[email protected],[email protected]'
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

'[email protected],[email protected],[email protected]'.split(',')

outputs:

 ['[email protected]', '[email protected]', '[email protected]']

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 = '[email protected],[email protected],[email protected]'
msg["To"] = ', '.join(email_string.split(',')

This would pass the following single string:

[email protected], [email protected], [email protected]

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:

'[email protected]','[email protected]','[email protected]'

edited Feb 10 '18 at 14:53

answered Feb 10 '18 at 14:36

Martin Evans

`msg["To"]` does not need space after comma. "[email protected],[email protected],[email protected]" 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