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

Help Activities
,
1

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.

2

@ack940129

Is that is fixed string or there are any changes?

Thanks

3

Hi, This is fixed string. Thanks

4

Check as below

image
image965Ă—439 19.7 KB

5

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

6

@ack940129

Here is the fileSplitString.zip (3.1 KB)

Mark as solution if this helps

Thanks

7

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

8

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

1 Like
9

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

1 Like
10

Hi @Srini84,
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)

11

@ack940129

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

Hope this helps

Thanks

12

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

image
image1882Ă—120 9.4 KB

13

@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

14

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

15

@ack940129

Check as below

SplitCells.zip (16.3 KB)

Hope this helps you

Thanks

1 Like
16

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

1 Like
17

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