Split the data from 1 column into 2-3 columns in Excel Uipath

Hi All,

As title, is anyone know how to split the data from 1 column into 2 columns? you may refer to below for the example. Thanks.

The Column I have
image

This is what I want to show my excel
image

I have no idea on how to do this after searching online. Hope someone can assist.

@ack940129

Is that is fixed string or there are any changes?

Thanks

Hi, This is fixed string. Thanks

Check as below

Wow, so much help for me, can u please share me the activity? Much appreciated!

@ack940129

Here is the fileSplitString.zip (3.1 KB)

Mark as solution if this helps

Thanks

Hi @ack940129
Store that value to a variable and apply these REGEX
image
image
image

Store those three to different variables and write to csv/xl.
Mark this as solution if this helps.
Regards,
Aditya

Thanks! Let me try it out and get back to you.

1 Like

Hi @desineediaditya, thanks for your reply. Let me try it out and get back to you!

1 Like

Hi @ksrinu070184,
I tried to read from Excel and write to Excel using your example, am i missed out anything as i received an error. Could you pls assist to help me modify, I have attached both xaml and excel file. Thanks
read.xlsx (11.1 KB)
Main.xaml (13.8 KB)

@ack940129

can you try row(“Column1”) instead of row(0)

Hope this helps

Thanks

Hi @ksrinu070184,
The result I want to show is something like this as below.

@ack940129

Attach the project.json file also, so that i will try to change the flow

Also check below post too, to set the value to datatable

https://forum.uipath.com/t/convert-date-time-format-tutorial/242670/2

Thanks

@ksrinu070184
Here you go. Thanks
BlankProcess23.7z (19.9 KB)

@ack940129

Check as below

SplitCells.zip (16.3 KB)

Hope this helps you

Thanks

Thanks bro! It’s work perfectly. Much appreciated!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.