Once Upon a File - Navigating Data Import and Export Challenges

Once Upon a File - Navigating Data Import and Export Challenges

Dyalog User Meetings via YouTube Direct link

UTF-8, ⎕NREAD, ⎕NGET and BOM

11 of 17

11 of 17

UTF-8, ⎕NREAD, ⎕NGET and BOM

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. 1 About SimCorp Sofia
  2. 2 Problems dealing with data import and export
  3. 3 Common formats used in Sofia
  4. 4 Issues with plain text files
  5. 5 Operating system-specific line endings
  6. 6 Tables in fixed width text files
  7. 7 Fixed width delimited file
  8. 8 Comma Separated Values CSV
  9. 9 Quotation marks
  10. 10 Confusing CSV and Microsoft Excel files
  11. 11 UTF-8, ⎕NREAD, ⎕NGET and BOM
  12. 12 XML
  13. 13 Microsoft Excel
  14. 14 Formatted cells
  15. 15 Regional settings and datetimes
  16. 16 Using Excel program to read and write files
  17. 17 How to cope when things go wrong

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.