How to split a cell string into two cells?

[lmoham]

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.

[vignesh.ks]

Hi @lmoham

Filter the column which contains ‘+’ symbol, then hydrate the filtered data table and use split function to sperate the value.

Thanks.
Happy Automation

[Hiba_B (Hiba Beldi)]

Hi @lmoham !
Here is a suggestion: Get_unique_column_content.xaml (9.3 KB)
I worked with the following excel file, the input is in Sheet1, the output in Sheet2: file_.xlsx (10.6 KB)

Let us know if it does not work as expected or if you need more info on the code !

[lmoham]

Thanks everyone, I got it to work as expected thanks for pointing me in the direction!

[Hiba_B (Hiba Beldi)]

That’s great to hear !!
Don’t forget to mark as solved your topic so we can focus on unresolved ones