Logic to separate the emails

[NayanaH_P]

Take input as 4-5 email ids separated by semicolon in a data item. Use logic to separate the email ids and fill in to different rows of collection(1 email id each in 1 row).
which function and the logic i have to use to store like above.

------------------------------
Nayana H P
------------------------------

[EmersonF]

Let me see if I understand, you have a string containing email ID separated by virgula and you want to separate? If yes you can use split by passing the ";" as a stopmeter it will return a collection with the ids separated by line 

If this was useful mark as best answer 🙂

------------------------------
Emerson Ferreira
Cons, Intelligent automation
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

[Neel1]

hello Nayana- use Split text ACTION in Utility string VBO and you will get all mail ID in a collection in each row.

In split character fee this ";"

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

[NayanaH_P]

Hi Neeraj Kumar,
I used split text action in Utility string...the emails are storing in collection but in a single row.
what should I do now to store each emails in a different row.

------------------------------
Nayana H P
------------------------------

[Neel1]

Please can you share the input you have feed to this action.

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

[NayanaH_P]

inputs are email Id

------------------------------
Nayana H P
------------------------------

[NayanaH_P]

I want the logic to do this without using the split text action.

------------------------------
Nayana H P
------------------------------

[EmersonF]

Could you share a screenshot of how you receive the items? To get a better view and help you in the best way

------------------------------
Emerson Ferreira
Cons, Intelligent automation
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

[EmersonF]

Hi Nayana all right? I still don't understand why I don't use split, and it's the best solution and the safest too, 
But come on, you can use the; to delimit the amount of characters you want to search, after delimiting, you can save this in a variance and use wherever you want, after capturing you must remove these characters using some combined with Left and Len, something like this Left([Num Character])) to get the characters and substisure it by fazio and do so until you finish all the ID

------------------------------
Emerson Ferreira
Cons, Intelligent automation
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

[NayanaH_P]

No I have a task to do that without using split text action.
So i need a logic to do .

------------------------------
Nayana H P
------------------------------