News for hackers. Stuff that matters.

A comment on Awk: `Begin { ` Part 1. Parent comment

Re:Awk: `Begin { ` Part 1 by lmns on Friday October 30, 2020 @09:19AM (#24941914)
Sqlite3 can import and export CSV via the CLI application. Both Ruby and Python provide CSV parsers in their standard library.
[ Parent | on HN ]
Re:Awk: `Begin { ` Part 1 by dotancohen on Friday October 30, 2020 @11:36AM (#24943324)
Thank you. I've used sqlite, but being able to query the data is not the same as being able to browse that data.

For instance, consider a project that I'm currently working on. Google Docs sheet exported to CSV. The file documents dozens of servers used as load balancers, websites, and database servers. The files has gone from MS Excel to Google Docs, and been maintained by four admins over 12 years. There are no columns per se, rather "sections of rows", each of which isn't even consistent in itself. One section is double columned, with the top row listing public IP address, login name, etc and the second row listing LAN IP address, login password, etc.

sqlite is useless on these files and frankly I've seen these things more often than well-formatted spreadsheets at every company I've ever worked with. Nobody but software developers treat spreadsheet columns as database fields.

[ Parent | on HN ]
Re:Awk: `Begin { ` Part 1 by lmns on Saturday October 31, 2020 @04:49AM (#24949941)
I know, there is no easy fix for that.
[ Parent | on HN ]
Re:Awk: `Begin { ` Part 1 by dotancohen on Sunday November 01, 2020 @10:33AM (#24960111)
Just a heads-up, if you're interested. I'm writing an app in Python for browsing spreadsheets:

https://github.com/dotancohen/osheet

[ Parent | on HN ]
Re:Awk: `Begin { ` Part 1 by 7thaccount on Friday October 30, 2020 @09:26AM (#24941962)
Doesn't it convert everything to strings including numbers? Or can you specify types?
[ Parent | on HN ]
Re:Awk: `Begin { ` Part 1 by lmns on Saturday October 31, 2020 @04:50AM (#24949942)
You have to provide a schema anyway, so you can treat specific columns as integers.
[ Parent | on HN ]
Re:Awk: `Begin { ` Part 1 by fnord123 on Friday October 30, 2020 @10:25AM (#24942525)
sqlite won't fail on bad types but you can do maths (e.g. sum, etc) on numeric columns,
[ Parent | on HN ]