topic RE: Logic to separate the emails in Product Forum

Logic to separate the emails

NayanaH_P — Wed, 10 Aug 2022 14:31:00 GMT

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
------------------------------

RE: Logic to separate the emails

EmersonF — Wed, 10 Aug 2022 14:49:00 GMT

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!
------------------------------

RE: Logic to separate the emails

Neel1 — Wed, 10 Aug 2022 14:52:00 GMT

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
------------------------------

RE: Logic to separate the emails

NayanaH_P — Wed, 10 Aug 2022 15:31:00 GMT

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
------------------------------

RE: Logic to separate the emails

Neel1 — Wed, 10 Aug 2022 15:39:00 GMT

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

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

RE: Logic to separate the emails

NayanaH_P — Wed, 10 Aug 2022 16:03:00 GMT

inputs are email Id

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

RE: Logic to separate the emails

NayanaH_P — Wed, 10 Aug 2022 17:52:00 GMT

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

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

RE: Logic to separate the emails

EmersonF — Wed, 10 Aug 2022 21:10:00 GMT

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!
------------------------------

RE: Logic to separate the emails

EmersonF — Wed, 10 Aug 2022 22:37:00 GMT

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!
------------------------------

RE: Logic to separate the emails

NayanaH_P — Thu, 11 Aug 2022 05:50:00 GMT

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

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

RE: Logic to separate the emails

PabloSarabia — Thu, 11 Aug 2022 13:16:00 GMT

Hi @NayanaH_P

Sorry but I don't understand why the solutions from @EmersonF and @Neeraj Kumar have not worked.

I try it in my local and it split all in 3 different rows inside the same Collection

I assume that you receive something similar to this:

When you call the action "Split Text" from the VBO "Utility - Strings" you need to indicate the original text and the char to split. And as output parameter the collection that you want to store the info. This function has a third parameter, the "Collection Field Name". If you didn't fill this field, you need to add manually a column in your output collection called "Column1" (If you don't make this, the process will fail) (Maybe this was the problem, I don't know)

This is how I call it

And this is the info that I have as output:

I understand well from your last messages. You want to achieve this, without using the split function. This is hard, but not impossible... I try to explain, but as my friends have said, this is not the best way to do it.

This is the schema:

The idea of this is to make a loop over the text that contains all the mails. This loops ends when the Char Index of ";" inside the original text is 0 (means that no more mails in the text)

For every step of the loop I storage the info in the collection and replace the mail that I have storage in the collection for "".

This is what you are looking for? Or I'm wrong?

Hope this helps you!

See you in the Community, bye 🙂

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------

RE: Logic to separate the emails

EmersonF — Thu, 11 Aug 2022 14:21:00 GMT

This worked for me, every time I needed it

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