Indeed. I can attest to lots of Python code for cleaning up dirty data.
I don't use/have MS Office, so I usually jump directly to a CSV or TAB file, if available. I've even had to edit my "csvfile" class to handle the broken CSV generated by WordPress (they don't handle fields with embedded double-quotes at all according to RFC 4180).
If only so much of everyone else’s data didn’t come via spreadsheet, I’d have no need of Libre Calc. When VisiCalc was described as a “killer app,” we had no idea how much collateral damage it would inflict.
Heh, yeah. Then Lotus 1-2-3 came along and killed the killer app and became the default software for office people everywhere for everything. People used to write letters using it. 🤯
Indeed. I can attest to lots of Python code for cleaning up dirty data.
I don't use/have MS Office, so I usually jump directly to a CSV or TAB file, if available. I've even had to edit my "csvfile" class to handle the broken CSV generated by WordPress (they don't handle fields with embedded double-quotes at all according to RFC 4180).
If only so much of everyone else’s data didn’t come via spreadsheet, I’d have no need of Libre Calc. When VisiCalc was described as a “killer app,” we had no idea how much collateral damage it would inflict.
Heh, yeah. Then Lotus 1-2-3 came along and killed the killer app and became the default software for office people everywhere for everything. People used to write letters using it. 🤯