anil.kallapari
New Member
Hi All,
I am relatively new to Blue prism.I have a scenario where in I have Multiple columns in my excel sheet and i have to split the text and add them to another collection
My input is some thing like below
Account ID Name Address
1243434 John Smith 139,Flowers,Little Green,Essex
So I have to Split the name with space as delimiter and add to new collection as first name and last name.
Same with the Address field i have to split with comma as delimiter and add to different columns in the new collection.
Could you please suggest the possible ways to achieve this.
Thanks in Advance
I am relatively new to Blue prism.I have a scenario where in I have Multiple columns in my excel sheet and i have to split the text and add them to another collection
My input is some thing like below
Account ID Name Address
1243434 John Smith 139,Flowers,Little Green,Essex
So I have to Split the name with space as delimiter and add to new collection as first name and last name.
Same with the Address field i have to split with comma as delimiter and add to different columns in the new collection.
Could you please suggest the possible ways to achieve this.
Thanks in Advance