Image 1:
So I have to separate the address in the Addresses column from Image 1 where all the IP addresses are kept in a comma delimited cell into the output of Image 2. How do I do this?
Would really appreciate your help!
Thanks in advance!
Hi @abdul.aziz1
Please find the pseudo code below and implement according to in UIPath.
Please let me know if you need anything, note that delimitter to split string address is comma
Hello! Thank you for your invaluable help! It kinda worked but for some reason, at certain points while running the program, I got the error message that “Write Cell: The range doesn’t exist”. But if I ignored it and continued on, then the program ran fine for some time after which the same error message popped up and if I ignored it, then it continued on. This happened 9 times during the runtime. What could be the issue do you think?
@abdul.aziz1
What are you assigning to ipaddressarray?
Also let me know cell value you are passing
the column where all the data is kept, separated by comma
ipAddressArray = row.Item(“Addresses”).ToString.Split(","c)
the cell values looks like this
I asked cell value of write cell activity
Oh sorry. It’s “A” + counter.ToString
share the excel and xaml @abdul.aziz1
Main.xaml (49.5 KB) Microsoft IPs.xlsx (19.7 KB)
here you go
Hello! Could you figure out what seems to be the problem? I can’t find it no matter how much I try. 
