Completed
Confusing CSV and Microsoft Excel files
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Once Upon a File - Navigating Data Import and Export Challenges
Automatically move to the next video in the Classroom when playback concludes
- 1 About SimCorp Sofia
- 2 Problems dealing with data import and export
- 3 Common formats used in Sofia
- 4 Issues with plain text files
- 5 Operating system-specific line endings
- 6 Tables in fixed width text files
- 7 Fixed width delimited file
- 8 Comma Separated Values CSV
- 9 Quotation marks
- 10 Confusing CSV and Microsoft Excel files
- 11 UTF-8, ⎕NREAD, ⎕NGET and BOM
- 12 XML
- 13 Microsoft Excel
- 14 Formatted cells
- 15 Regional settings and datetimes
- 16 Using Excel program to read and write files
- 17 How to cope when things go wrong