I have the following unstructured text in excel.
how can I tell the robot take my part before the comma, then take my second part, then the third, etc. the output foe each is: on the first turn 1111 on the second 2222 on the third 3333, etc. while there is data
Hello @pl.rusinov
You can use For each row in datatable to loop through the rows and use Split command to split with comma.
1)for each row activity
2)row(0).ToSTring.Split(“,”)
3)Above expression gives you array of string. Then use the index to get each value.
Hi @pl.rusinov,
You can split currentRow(“Account”).ToString() by ‘,’ which returns IEnumerable of string (containing 1111,2222 etc).