3 ms·
As I recall, you can tell Awk to use the control characters as record and field separators. Not helpful if you're getting your data from others, but if you're w
by bachmeier 3y ago
As I recall, you can tell Awk to use the control characters as record and field separators. Not helpful if you're getting your data from others, but if you're working by yourself, you have the option. I've come to use control characters as a default because it makes life so much easier.
- ufo 3y agoWhat do you recommend for viewing and editing such files?
- ac29 3y agoVisidata works with arbitrary separators. I just tried with a CSV separated with ␟ (ASCII unit separator) and it worked just fine.
- lolive 3y agoExcel too?
- leonim 3y agololive, VisiData has some Excel support. However, don't expect VisiData to be a full blown editor for Excel files. It can provide a view of the data in an Excel spreadsheet.
- dotancohen 3y agoI think GP means to ask if Excel can read files with ASCII 29,30,31 separators.
- smitty1e 3y agoIf you have a python installation available, openpyxl[1] is great both for converting to .csv and for packaging .csv outputs as .xlsx (which is really zipped .xml, anyway). [1] https://openpyxl.readthedocs.io/en/stable/index.html https://openpyxl.readthedocs.io/en/stable/index.html