Forum Discussion
Solved
split or extract?
Hi, I have a column including datetime that the format is 2025-07-07 at 12:40. Which one solution is better? "split by using delimiter at" or "apply a tramsform to extract the column first 11 cha...
mamatea1218 If format is constant then extracting first 11 characters is good because Extracting a fixed number of characters is generally faster and less error-prone and It is straightforward if the date part is always exactly 11 characters long.
If there is any possibility of variation in the format, splitting by delimiter might be a safer choice.
Hi mamatea1218 ,
Could you please confirm if the issue has been resolved on your end? If so, sharing the solution here would be helpful for other community members who may have similar issue.
Thank you.