Hello Community
Say I have multiple cells like “AT012+AT034” with some of them just being alone as “AT045” all under one column and I want the bot to read all the data and only write out unique names, but the ones like “AT012+AT034” have to be separated into two cells first “AT012” and then “AT034”.
How can I achieve this? I am aware of the code datatable.DefaultView.ToTable(True,“Column Name”) but am not sure about the splitting part.