Hai, I need yor help. I don’t know im couldn’t find a solution. I want to separate this data. [image] To be like this. [image] I am confused because the data has 2 separator “ “spaces” and “/“. I need advice to solve it. Thank You

Hi, Did you try my above sample? it returns what you expect as the following. [image] Sample20230307-4Lv2.zip (14.5 KB) Regards,

How to separate data with 2 separators

fernando_zuluaga (Fernando Zuluaga) March 9, 2023, 4:23am 13

Kindly mark @Yoichi post as solution, so other people with the same problem will reach the solution fastly
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

Regards!

Topic		Replies	Views
How to Achieve Multiple Column Separators in Generate Data Table? Activities excel , activities , question	7	1908	April 11, 2021
Separate text from a txt file in cells of a data table Help studio	1	840	July 18, 2019
In the Generate Datatable activity, How to use 5 spaces as a column seperator Studio studio , question , string-manipulation	6	756	January 3, 2024
DataTable->String; value with separator Help	6	2858	February 11, 2019
How to remove all spaces from the string except newline Activities excel , activities , question	10	2783	December 25, 2021