Have to split the date in two seperate column using Uipath

Help Something Else
1

image
Need to split the date in two seperate column in excel

2

@Santhiya_0412

read the data into datatable then add two new columns to the datatable

use a for each row in datatable activity and inside use

assign 1
currentrow("NewCol1") = currentrow("OldCol").ToString.Split({"Relieving Letter :","Service Letter :"},StringSplitOptions.RemoveEmptyEntries)(0).Trim
assign 2
currentrow("NewCol2") = currentrow("OldCol").ToString.Split({"Relieving Letter :","Service Letter :"},StringSplitOptions.RemoveEmptyEntries)(1).Trim

Now write the data back to excel

cheers