* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *
This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
Description
CSV module add functionalists for reading RFC 4180 CSV delimited files.
How to use this module
Inside your script, before calling any module specific keyword, add the following:
USES "CSV"
Specifications
A moderate performance, low memory, modified RFC 4180 CSV delimited file reader.
Module will skip blank lines
it allows for a remark character which is the pound symbol (#) by default.
You can change the delimiter. The delimiter defaults to a comma (,) but can be changed to a tab or any other character.
It fully supports any characters embedded inside the quotes including carriage returns and line feeds.
A double quote can be embedded by including two double quote. ("") i.e. "This ""is"" a test" when read, it will return This "is" a test.
Note that ColumnNames, delimiter character, and remark character can only be changed before the CSV reader is opened.
If a file does not have column headers, you can assign column names if you want. If you don't the columns will be labeled c1, c2, c3 etc.
Tests with CSV files of up to 2M rows and up to 100K columns
Additional information
Important notes about CSV module
1. CSV thinBasic module is based on by Larry Charlton sources with some modifications
|
