3 ms·
Yes. I did a project ETL'ing data that used the ASCII field and record separators once. It was a joy to deal with compared to CSV.
by EvanAnderson 3y ago
Yes. I did a project ETL'ing data that used the ASCII field and record separators once. It was a joy to deal with compared to CSV.
- cpeterso 3y agoThis is definitely the Right Thing, but how well did other software, such as text editors, handle or render the field and record separator characters? That you can’t directly enter these characters on a keyboard would be a minor annoyance.
- EvanAnderson 3y agoThe file I used was being generated by a partner company's ERP system so I didn't really have to make any files myself. Having said that, I use a lot of Notepad++ on Windows and using the ALT-029, ALT-028, etc, syntax generated the right codes for direct keyboard entry. They're displayed by Notepad++ as inverse text "RS", "GS", etc.