Splitting the output from data table

Hi Team,

Im having issues where i want to separate 2 outputs that i got from a data table. What I want to achieve is everytime i do a look up in one spreadsheet and found 2 identical account number with only an exception of dashes at the end of it (ex. 123456-1 , 123456-2). After i get those account numbers, i will write it back in a different spreadsheet in 2 different cells. I was able to get that but it actually write back in one cell only. Please see screen shot below. Thank you

image

1 Like

buddy after add data row activity with which you add rows to the build datatable by build datatable activity in the beginning(hope so, if not kindly correct),
use write range activity buddy with that datatable as input after the for each row loop buddy
That would work…

Kindly correct me if i have understood your question wrongly
Cheers @julius.mapili

Here’s the output;

image

I want to achieve is to split those output and write it back in different cells. Thank you

1 Like

fine @julius.mapili
like if a string variable is passed to messagbox named in_text
you can split like this buddy
in_text_value1 = in_text.split(Environment.Newlines.ToArray())(0).ToString
in_text_value2 = in_text.split(Environment.Newlines.ToArray())(1).ToString

so the output would be
in_text_value1 = 1061341615-1
and
in_text_value2 = 1061341615-2

Try this and let know buddy
Cheers @julius.mapili

1 Like

Thank you @Palaniyappan

Great help!

1 Like

Did that get resolved buddy @julius.mapili