the field contains 2 emails

[CiaoPaola]

Hi, 

the legacy table contains a single Email column that may contain 2 emails separated with a whitespace. 

The target table contains two Email fields : Email1 and Email2. 

I need to put the second email into the Email2 field. 

I cannot figure out how to do that. Can you help me? 

thank you

Paola

[AkimasaKajitani]

Hi @CiaoPaola 

You can use Text To Columns tool.

Set to "Split to columns"

Delimiters : you can input space or "\s".

Result : 

[CiaoPaola]

Hi Akim, cool solution indeed!

How can I select only the rows that contains 2 email addresses?

[AkimasaKajitani]

Hi @CiaoPaola 

If you have only one email at Email field, that workflow will work well.

If you have another situations, please let me know.

[CiaoPaola]

Hi Akim,

yes I have other typing mistakes such as: 

sample sample@email.com

sample@email. com

sample@ email.com

so before splitting the columns in 2 columns, I need to fix these typing mistakes first, don't I ? 

thank you

[AkimasaKajitani · Accepted solution]

Hi @CiaoPaola 

I added the your sample and then I change the workflow.

If the 2 emails row contain miss type, the workflow will not work well.

But it is work well at your sample.

Workflow

I split the contain 2 email or not and then I replace space on the data stream that not contain 2 email.

After that, I union 2 data stream and split the space.

Input

Result

[CiaoPaola · Accepted solution]

Just splendid Akim! 

You made my day!!

thank you so much

[CiaoPaola]

Akim, 

may I ask you another question re Phone numbers in another thread? 

[AkimasaKajitani]

Hi @CiaoPaola 

Yes, of course.

I or another community member will respond to you.

[CiaoPaola]

thanks a lot!