Meet the UiPath Platform i want to separate this word in excel using space delimiter and save single word in each cell

Hello @vimal You can try with text to columns activity [image] [image] Checkout the sample flow Main.xaml (9.2 KB) Regards Sudharsan

Hello @vimal Try this YourString=" Meet the UiPath Platform " Strings.Split(YourString," ")(0).Tostring.Trim -->Meet Strings.Split(YourString," ")(1).Tostring.Trim --> the Strings.Split(YourString," ")(2).Tostring.Trim --> Uipath Strings.Split(YourString," ")(3).Tostring.Trim -->Platform U…

Hi @vimal , What about this workflow output [image] workflow [image] Xaml 14.xaml (8.0 KB) Thanks, Rajkumar

Hello, You can use generate data table in which you can pass your string variable and select comma separator. So Generator data table give data variable and then you can write into excel

Hey @vimal , Refer this video it here you will get to know how you can use linq to split one column into multiple columns. [UiPath Use Case | Split One Column into Multiple Columns | UiPath Tutorials | #Coderslobby] Thanks, Sanjit

How can we separate one column data using space in excel

Help StudioX

Sanjit_Pal (Sanjit Pal) December 19, 2022, 8:42am 6

Hey @vimal ,

Refer this video it here you will get to know how you can use linq to split one column into multiple columns.

Thanks,
Sanjit

Topic		Replies	Views
Separating string in an excel column Activities excel , activities , question	6	1359	September 25, 2021
Split Keywords column into string Help datatable , excel , uiautomation , activities , question	2	935	November 12, 2020
Excel Separate Column or Split Activities excel , activities	4	411	July 5, 2023
How to one column's values into two separate columns in UiPath? Help	4	2226	April 11, 2019
In excel automaion how to split the columns data Help studio	2	1374	June 29, 2019

How can we separate one column data using space in excel

Related topics