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.
Yeah look I’m not an AI advocate at all. If I were confronted with this my first instinct would be to manipulate it in a spreadsheet because they can juggle data types like this pretty effortlessly.
The CSV / dates thing was just an example, but I still think it’s a good one. My assistant at work would 100% use notepad like this rather than using a spreadsheet.
It’s also worth pointing out that notepad + LLM would be a lot more flexible than a spreadsheet. Just paste whatever there and explain what you want in plain english. You don’t need to parse your request into regex or spreadsheet formulas. For you and I, we might have spent years interacting with regex and other things such that it’s a pleasant challenge when it arises. For 20 year old me it would have been a tedious impediment to whatever I was trying to achieve.
Yeah. That makes a lot of sense. The general inaccuracy/untrustworthiness of LLMs makes me very uncomfortable in their use for data processing and transformations. I’d rather take a while to get it right than to potentially hand off a CSV with glaring problems due to use of an LLM.
I think the idea is that you can use it for reformatting small sets of data I guess.
“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.
Yeah look I’m not an AI advocate at all. If I were confronted with this my first instinct would be to manipulate it in a spreadsheet because they can juggle data types like this pretty effortlessly.
The CSV / dates thing was just an example, but I still think it’s a good one. My assistant at work would 100% use notepad like this rather than using a spreadsheet.
It’s also worth pointing out that notepad + LLM would be a lot more flexible than a spreadsheet. Just paste whatever there and explain what you want in plain english. You don’t need to parse your request into regex or spreadsheet formulas. For you and I, we might have spent years interacting with regex and other things such that it’s a pleasant challenge when it arises. For 20 year old me it would have been a tedious impediment to whatever I was trying to achieve.
Yeah. That makes a lot of sense. The general inaccuracy/untrustworthiness of LLMs makes me very uncomfortable in their use for data processing and transformations. I’d rather take a while to get it right than to potentially hand off a CSV with glaring problems due to use of an LLM.
Genuinely very useful, however I feel that can be achieved without a login and paid AI subscription.
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.
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.