netCSV

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

Contents

netCSV

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

Download netCSV.v1.0.txt
Do a Select all (Ctrl+A) and a copy (Ctrl+C).
In your workspace execute )ed ⍟ netCSV
Paste (Ctrl+V) the text into the Dyalog editor
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)

Original author:	Pierre Gilbert
Responsible:	PierreGilbert
Email:	`<apgil AT SPAMFREE videotron DOT ca>`

CategoryDyalog - CategoryDyalogDotNet - CategoryDyalogDotNetUtilities - CategoryDotNet

-  ⇤ ← Revision 1 as of 2016-02-06 14:05:39 → 
  Size: 2111
  Editor: PierreGilbert
  Comment: Under construction
+   ← Revision 2 as of 2016-02-07 00:55:59 → ⇥
  Size: 2245
  Editor: PierreGilbert
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 10:
-`netCSV` is a Dyalog namespace that contains useful functions for reading a [[https://en.wikipedia.org/wiki/Comma-separated_values/|comma-separated values (CSV)]] file directly into a [[https://msdn.microsoft.com/en-us/library/system.data.datatable%28v=vs.110%29.aspx|DataTable]]. The !DataTable can be used later for [[netDataTable#Binding_a_DataTable|binding]] or [[http://aplwiki.com/netDataTable#To_Query_a_DataTable_.28Contributed_by_Richard_Proctor.29|querying]]. The CSV file will not transit in the APL workspace and may not cause a WORKSPACE FULL ERROR. The namespace is using an assembly named `LumenWorks.Framework.IO.dll` that is the work of [[http://www.codeproject.com/Articles/9258/A-Fast-CSV-Reader|Sébastien Lorion]] and [[https://www.nuget.org/packages/LumenWorksCsvReader/|Paul Hatcher|]] and must be installed in the same directory has `dyalog.exe`.
+`netCSV` is a Dyalog namespace that contains useful methods for reading a large [[https://en.wikipedia.org/wiki/Comma-separated_values|comma-separated values (CSV)]] file directly into a [[https://msdn.microsoft.com/en-us/library/system.data.datatable%28v=vs.110%29.aspx|DataTable]]. The !DataTable can be used later for [[netDataTable#Binding_a_DataTable|binding]] or [[http://aplwiki.com/netDataTable#To_Query_a_DataTable_.28Contributed_by_Richard_Proctor.29|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 [[http://www.codeproject.com/Articles/9258/A-Fast-CSV-Reader|Sébastien Lorion]] and [[https://www.nuget.org/packages/LumenWorksCsvReader/|Paul Hatcher|]] and must be installed in the same directory has `dyalog.exe`.<<BR>>

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