“make all the dates in this CSV iso-8601”
This is a use of AI/LLM processing that I could agree with, if it could be trusted. Since it cannot, better to open in vim and regex replace, or process with Python.
That said, I’d rather store as epoch and display as ISO-8601 as the arithmetic is much less prone to error in epoch than any other format.
TheGrandNagus@lemmy.world 5 weeks ago
Genuinely very useful, however I feel that can be achieved without a login and paid AI subscription.
lambalicious@lemmy.sdf.org 5 weeks ago
Heck, it probably can be done with a regex. (Yeah, I know)
There’s no need to kill three forests just to do the exact same work you could have done by opening your dataset in Excel.
null_dot@lemmy.dbzer0.com 5 weeks ago
You’re right of course.
Like the other commenter said for this specific problem you’d use a spreadsheet.
It’s just an example though and there are others, like maybe removing url encoding from a string or something.
Again this can be done in some other tool without much fuss, but the versatility offered by notepad will be useful for a lot of people.