How to masage excel data and bring it to certain Format

Help Robot
,
1

I have excel data like this :

image

Each Cell has 2 lines, 1st line is the message and second line the time, The format in which I need the data is :

image

Basically I need to bifurcate the message and time in 2 different columns.

Kindly suggest

1 Like
2

HI,

Hope the following sample helps you.

image
image673×705 19 KB 

dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow(r(0).ToString.Split(vbCrLf.ToCharArray,StringSplitOptions.RemoveEmptyEntries),False)).CopyToDataTable

ample20230317-5L.zip (8.3 KB)

Regards,

1 Like
3

Hii @Ishan_Shelke ,
Please check this workflow

AddColumn.zip (2.0 KB)

Hope this helps :slightly_smiling_face:

1 Like
4

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