Date and time extension

[soumi_soumiya]

From this i had separated the date 18jul2019 using function
dmy.Split({" “},StringSplitOptions.None)(1)+dmy.Split({” “},StringSplitOptions.None)(2)+dmy.Split({” "},StringSplitOptions.None)(3)
to remove the time 101401 i dont know how to split if i use the above function with index 4,5,6 then it gives an excess array exception
Can any one help me.
Regards
Soumiya.S

[Vashisht (Vashisht Devasani)]

HI @soumi_soumiya,
You want 101401?

[Vashisht (Vashisht Devasani)]

You can use the substring function for getting the only required part of the string.

[sandeep13 (Sandeep Pathak)]

@soumi_soumiya
Use substring method to extract required part
Or if you want split text…you can use spilt method with space delimiter

Thanks

[monika.c (Monika Chaudhari)]

hi @soumi_soumiya
If you want 101401 from your string value then try this…Split.zip (10.8 KB)