Главная
Study mode:
on
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
Description:
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

Dyalog User Meetings
Add to list