Thank You its working:grinning:
Use Excel scope activity within it use get row item activity for the column u want to fetch the date after that
assign a variable
(for fetching day)
1.newdate= rowtext // output of get row item
2.newdateconverted = Left(rowtext.ToString,4)
3.fetchdate = newDate.ToString(“dd”)
similarly do for fetching month and year
Change from row(0).tostring to row(2).tostring
For write cell just indicate the column letter which is D for month and E for year.
Please note that the datatable output column index is 0, so column A = 0, B = 1, C = 2, and so on…
You just have to change Cells in Write Range from B & C to D & E that would work and Get Item Row column index would be 2 according to new file
ok i will try it
thanks
Hi …
see in my file i m getting follwing result
please help with my file
Did you change the index of the datatable row?
yes…see above screenshot
Can anyone provide me solution with this file for split month and year and write them into respective columns…
Excel.xlsx (136.2 KB)
Thanks in advance
ok thank you…i will check it and let you know