the field contains 2 emails
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Preparation
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @CiaoPaola
You can use Text To Columns tool.
Set to "Split to columns"
Delimiters : you can input space or "\s".
Result :
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Akim, cool solution indeed!
How can I select only the rows that contains 2 email addresses?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Akim,
yes I have other typing mistakes such as:
sample 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just splendid Akim!
You made my day!!
thank you so much
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Akim,
may I ask you another question re Phone numbers in another thread?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks a lot!