• netCSV

netCSV

(Show (Hide table-of-contents) table-of-contents)

Overview

netCSV is a Dyalog namespace that contains useful methods for reading a large comma-separated values (CSV) file directly into a DataTable. The DataTable can be used later for binding or querying. The large CSV file will not transit in the APL workspace and may not cause a WORKSPACE FULL ERROR. The netCSV namespace is using an assembly named LumenWorks.Framework.IO.dll that is the work of Sébastien Lorion and Paul Hatcher and must be installed in the same directory has dyalog.exe.

For a small size file or characters in the workspace you can use the functions as explained in CsvToApl.

SimpleCsvFileToDT

FastCsvFileToDT

DTtoCsvFile

CsvFileNew

CsvFileAddRecords

AplToCsvRecords

How to install netCSV in your workspace

1. Download netCSV.v1.0.txt

2. Do a Select all (Ctrl+A) and a copy (Ctrl+C).

3. In your workspace execute )ed ⍟ netCSV

4. Paste (Ctrl+V) the text into the Dyalog editor
5. Press Escape and ')save' your workspace

Optionally to de-script the namespace you can do:

'netCSV' ⎕SE.SALTUtils.CopyNs netCSV

Download LumenWorks.Framework.IO.dll and install the assembly in the same directory as dyalog.exe

Version Information

February 2016   - Initial version (1.0)

CategoryDyalog - CategoryDyalogDotNet - CategoryDyalogDotNetUtilities - CategoryDotNet