Hi
I have a column which has 3 values mix I want to make them separate.
Separate the 1 digit and create new column named - Number
Separate the date and create new column named - date // date can be in string format
remaining content as it is in same column
attaching sample excel column.
Sample.xlsx (9.5 KB)
Please find the below xaml for your reference
BlankProcess14.zip (73.9 KB)
O/P:
Sample (3).xlsx (10.4 KB)
Hope this helps!!
Hi @sasi_poosarla,
This solution adding both dates, but my req was to fetch 1 date.
However, this is useful for me in future. But can not mark as a solution as req added here is slight diff than the o/p getting.
Also, using UiPath I would prefer to do, but regex are useful
Thanks a lot 
@lrtetala
it works as expected
Thank you so much!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
