Substring problem
I have a string representing a date and time formatted as '01/02/2024/14:00'. My current approach encounters an issue where only the numbers before the first '/' are considered when using .unique, leading to incomplete data extraction. I'm exploring alternatives, such as using substring, but I haven't found a solution yet. Ideally, incorporating this into a .filter option would be beneficial for my needs. How can I accurately split this string into its constituent parts, such as day, month, year, and time, to work with each segment individually?

2 Replies