3 ms·
I did some ETL work that used the ASCII delimiter characters. It was very enjoyable. I didn't have to worry about escaping or parsing escaped strings. The contr
by EvanAnderson 2y ago
I did some ETL work that used the ASCII delimiter characters. It was very enjoyable. I didn't have to worry about escaping or parsing escaped strings. The control codes were guaranteed to be illegal in input. It was refreshing.
- theamk 2y agoCould you do the same with TSV? A lot of datasets can either prohibit tabs in data, or convert it to spaces in early ingestion.
- EvanAnderson 2y agoTSV is a joy compared to CSV, for sure. CLI tools that output TSV are what immediately spring to mind.
- bandie91 2y agoshameless plug: https://repo.or.cz/hband-tools.git/blob/HEAD:/tabdata/README.md https://repo.or.cz/hband-tools.git/blob/HEAD:/tabdata/README...
- red_admiral 2y agoYes, and as long as you remember to turn off the "TAB produces 4 spaces" thing in your editor (grumble makefiles grumble) it's really nice to work with.