Forum Discussion

mamatea1218's avatar
mamatea1218
New Member
1 year ago
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...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mamatea1218 ,
Thank you community members for the helpful insights!
Following up to check whether you got a chance to review the suggestion given.If it helps,consider accepting the helpful answer as solution,it will be helpful for other members of the community who have similar problems as yours to solve it faster.If still facing any issue, feel free to reachout. Glad to help.
Thank you.

Regards,
Pallavi.