Explore common challenges and amusing anecdotes related to file handling and data import/export in this 28-minute conference talk from Dyalog '23. Delve into the intricacies of various file formats, including plain text, fixed-width, CSV, XML, and Microsoft Excel. Learn about operating system-specific line endings, quotation mark issues, UTF-8 encoding, and the impact of regional settings on datetime formats. Discover strategies for dealing with formatted cells, using Excel programs for file operations, and coping with unexpected problems. Gain insights from Elena Paviotti and Gianna Folladore's experiences at SimCorp Sofia to improve your approach to file management and data processing.
Once Upon a File - Navigating Data Import and Export Challenges