Hi all, I’m working on an excel file, i have managed to get the datetime column to be copied out onto new column. But i want the column to be separated for time and date. Lets say if first column should contain the date only and the second column only store the time only. i try to use split on th…

@hairil.hashimie Issue was not with your data but there are empty rows after 1544 or 1545 which was causing this issue. Just created a flow. Please have a look. Case1.xaml (7.5 KB)

Hi, Thank you for your quick response. But how do i assign this in for each row activities. Given the row column name is “SLOT_PLAN_DATE”

Hi @hairil.hashimie [image] This might help you understand. Use for each row and assign columns with date and time

Hi, It is working fine but then i noticed there is some of row are not converted to the specified date format. it is still store in datetime type. did i do anything wrong cause i follow your expression exactly. [image]

It will only convert where we have exact date format match, if there is even extra space in any of those, it will not convert, to check it, you can use IF with datetime.tryparseexact.

Noted on that and by fact that was my concern on this thread. i was actually want to trim of two white space from that specific string. Have tried one using regex but seems like its not working. Currently still searching an option on how to remove 2 white spaces cause as for now the only i found jus…

[image] hairil.hashimie: paces cau [image] All dates format in a given string Studio @alpharobot the formats are configured in a dt: [grafik] so it can be externalized (less formats can be handled in comma seperated string and handled with String .Split…) follow…

Hi, I have read your answer on that thread. May i know as i’m still new in this. For that specific condition what it actually do yeah? Hope you don’t mind to explain so that i could get a better and more clear picture about uipath. [image]

@hairil.hashimie It depends on in and out use of particular object, but to keep it simple. I would have used tryparseexact as it will also control my flow and avoid any unknown exception in my flow. Also, if you can share a dummy file, I could have looked at it and told you a better approach.

@hairil.hashimie find some starte help: [grafik] dateTimes can be parsed by the strings, but its internal format is to keep and not to reformat. Alternate value representations are created on String Base

book1.xlsx (39.1 KB) Hi Lakshay, I have shared you a dummy file that is used in current thread. Thanks in advance for your help on this. On the replies below does it mean i could just parse any of this? i got query lets say if you just wanna parse the date only why should we bother about the time…

Split date and time column row

Help Studio

Lakshay_Verma (Lakshay Verma) June 20, 2020, 10:08pm 8

Topic		Replies	Views
Convert Datetime to Date & Time columns Activities question , system	7	499	September 19, 2023
Date format issue of excel file Activities excel , activities , question	21	1395	June 14, 2023
Change column type to datetime Activities excel , activities , bug	8	856	January 22, 2024
Assign Date Column Activities uiautomation , studio , question	4	722	March 1, 2021
Convert string into specific datetime format Activities excel , activities , question	5	5477	August 8, 2023

Split date and time column row

Related topics