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