CsvReader class - Revision history

Administrator at 06:55, 2 July 2020

2020-07-02T06:55:37Z

← Older revision		Revision as of 06:55, 2 July 2020
Line 2:		Line 2:
	\|Name=<nowiki>CsvReader</nowiki>		\|Name=<nowiki>CsvReader</nowiki>
	\|Description=<nowiki>Represents a reader that provides fast, non-cached, forward-only access to CSV data.</nowiki>		\|Description=<nowiki>Represents a reader that provides fast, non-cached, forward-only access to CSV data.</nowiki>
	\|Constructors=		\|InheritsFrom=object\|Constructors=
	{{CGscriptConstructors_Template\|Parameters=		{{CGscriptConstructors_Template\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>csvData</nowiki>\|Description=<nowiki>The string containing the text to be parsed as csv data</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>hasHeaders</nowiki>\|Description=<nowiki>true if field names are located on the first non commented line, otherwise, false.</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>delimiter</nowiki>\|Description=<nowiki>The delimiter character separating each field (default is ',').</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>quote</nowiki>\|Description=<nowiki>The quotation character wrapping every field (default is ''').</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>escape</nowiki>\|Description=<nowiki>The escape character letting insert quotation characters inside a quoted field (default is '\'). If no escape character, set to '\0' to gain some performance.</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>comment</nowiki>\|Description=<nowiki>The comment character indicating that a line is commented out (default is '#').</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>skipEmptyLines</nowiki>\|Description=<nowiki>A value indicating if the reader will skip empty lines.</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>supportsMultiline</nowiki>\|Description=<nowiki>A value indicating if the reader supports multiline field.</nowiki>}}		{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>csvData</nowiki>\|Description=<nowiki>The string containing the text to be parsed as csv data</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>hasHeaders</nowiki>\|Description=<nowiki>true if field names are located on the first non commented line, otherwise, false.</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>delimiter</nowiki>\|Description=<nowiki>The delimiter character separating each field (default is ',').</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>quote</nowiki>\|Description=<nowiki>The quotation character wrapping every field (default is ''').</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>escape</nowiki>\|Description=<nowiki>The escape character letting insert quotation characters inside a quoted field (default is '\'). If no escape character, set to '\0' to gain some performance.</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>comment</nowiki>\|Description=<nowiki>The comment character indicating that a line is commented out (default is '#').</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>skipEmptyLines</nowiki>\|Description=<nowiki>A value indicating if the reader will skip empty lines.</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>supportsMultiline</nowiki>\|Description=<nowiki>A value indicating if the reader supports multiline field.</nowiki>}}
	\|Description=<nowiki>Create a new reader.</nowiki>}}		\|Description=<nowiki>Create a new reader. Example:
			string empt = empty;
			CsvReader csv = new CsvReader(csvData, true, ";", "\"", empt, empt, true, false);

			number fieldCount = csv.FieldCount;
			array headers = csv.Headers;
			while(csv.ReadNextRecord()) {
			for(number i = 0; i < fieldCount; i = i +1) {
			string value = csv[i];
			if (value == empty) value = "MISSING";
			print(headers[i] + " = " + value);
			}
			print("---------");
			}
			</nowiki>}}
	\|Methods=		\|Methods=
	{{CGscriptMethods_Template\|ReturnType=~~string~~\|Name=<nowiki>this[] { get; }</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=object\|Name=<nowiki>this[] { get; }</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>field</nowiki>\|Description=<nowiki>The field with the specified name.</nowiki>}}		{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>field</nowiki>\|Description=<nowiki>The field with the specified name.</nowiki>}}
	\|Description=<nowiki>Gets the field with the specified name. Must have set hasHeaders to true when starting read.</nowiki>}}		\|Description=<nowiki>Gets the field with the specified name. Must have set hasHeaders to true when starting read.</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=~~string~~\|Name=<nowiki>this[] { get; }</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=object\|Name=<nowiki>this[] { get; }</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=~~number~~\|Name=<nowiki>field</nowiki>\|Description=<nowiki>The field at the specified index.</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>field</nowiki>\|Description=<nowiki>The field at the specified index.</nowiki>}}
	\|Description=<nowiki>Gets the field at the specified index.</nowiki>}}		\|Description=<nowiki>Gets the field at the specified index.</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=bool\|Name=<nowiki>ReadNextRecord</nowiki>\|Description=<nowiki>Reads the next record. true if a record has been successfully reads; otherwise, false.</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=bool\|Name=<nowiki>ReadNextRecord</nowiki>\|Description=<nowiki>Reads the next record. true if a record has been successfully reads; otherwise, false.</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Description=<nowiki>The string representation of the object.</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Inherited=object\|Description=<nowiki>The string representation of the object.</nowiki>}}
	\|Properties=		\|Properties=
	{{CGscriptProperties_Template\|ReturnType=~~number~~\|Name=<nowiki>FieldCount</nowiki>\|HasGetter=1\|Description=<nowiki>Gets the maximum number of fields to retrieve for each record.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=int\|Name=<nowiki>FieldCount</nowiki>\|HasGetter=1\|Description=<nowiki>Gets the maximum number of fields to retrieve for each record.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=array\|Name=<nowiki>Headers</nowiki>\|HasGetter=1\|Description=<nowiki>Gets the field headers.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=array\|Name=<nowiki>Headers</nowiki>\|HasGetter=1\|Description=<nowiki>Gets the field headers.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Description=<nowiki>Get information about this class.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Inherited=object\|Description=<nowiki>Get information about this class.</nowiki>}}
	}}		}}

Tungocman at 10:07, 19 December 2011

2011-12-19T10:07:36Z

← Older revision		Revision as of 10:07, 19 December 2011
Line 37:		Line 37:
	print(headers[i] + " = " + value);		print(headers[i] + " = " + value);
	}		}
	print("---------");		print("---------");
	}		}
	</source>		</source>

Tungocman at 10:07, 19 December 2011

2011-12-19T10:07:06Z

← Older revision		Revision as of 10:07, 19 December 2011
Line 29:		Line 29:
	number fieldCount = csv.FieldCount;		number fieldCount = csv.FieldCount;
	array headers = csv.Headers;		array headers = csv.Headers;
	while(csv.ReadNextRecord()) {		while(csv.ReadNextRecord())
	for(number i = 0; i < fieldCount; i = i +1) {		{
	string value = csv[i];		for(number i = 0; i < fieldCount; i = i +1)
	if (value == empty) value = "MISSING";		{
	print(headers[i] + " = " + value);		string value = csv[i];
	}		if (value == empty) value = "MISSING";
	print("---------");		print(headers[i] + " = " + value);
			}
			print("---------");
	}		}
	</source>		</source>

Tungocman at 10:06, 19 December 2011

2011-12-19T10:06:06Z

← Older revision		Revision as of 10:06, 19 December 2011
Line 22:		Line 22:
	}}		}}

	===Examples===		==== <span style="color:#a52a2a;">'''Examples'''</span> ====
	~~Example:~~
			<source lang="javascript">
	string empt = empty;		string empt = empty;
	CsvReader csv = new CsvReader(csvData, true, ";", "\"", empt, empt, true, false);		CsvReader csv = new CsvReader(csvData, true, ";", "\"", empt, empt, true, false);

	number fieldCount = csv.FieldCount;		number fieldCount = csv.FieldCount;
	array headers = csv.Headers;		array headers = csv.Headers;
Line 37:		Line 37:
	print("---------");		print("---------");
	}		}
			</source>

Tungocman at 10:22, 16 December 2011

2011-12-16T10:22:57Z

← Older revision		Revision as of 10:22, 16 December 2011
Line 21:		Line 21:
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Description=<nowiki>Get information about this class.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Description=<nowiki>Get information about this class.</nowiki>}}
	}}		}}

			===Examples===
			Example:
			string empt = empty;
			CsvReader csv = new CsvReader(csvData, true, ";", "\"", empt, empt, true, false);

			number fieldCount = csv.FieldCount;
			array headers = csv.Headers;
			while(csv.ReadNextRecord()) {
			for(number i = 0; i < fieldCount; i = i +1) {
			string value = csv[i];
			if (value == empty) value = "MISSING";
			print(headers[i] + " = " + value);
			}
			print("---------");
			}

Tungocman at 10:21, 16 December 2011

2011-12-16T10:21:32Z

@@ Line 1: / Line 1: @@
 {{CGscriptClass_Template
 |Name=<nowiki>CsvReader</nowiki>
@@ Line 6: / Line 5: @@
 {{CGscriptConstructors_Template|Parameters=
 {{CGscriptParameters_Template|Type=string|Name=<nowiki>csvData</nowiki>|Description=<nowiki>The string containing the text to be parsed as csv data</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=<nowiki>hasHeaders</nowiki>|Description=<nowiki>true if field names are located on the first non commented line, otherwise, false.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>delimiter</nowiki>|Description=<nowiki>The delimiter character separating each field (default is ',').</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>quote</nowiki>|Description=<nowiki>The quotation character wrapping every field (default is ''').</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>escape</nowiki>|Description=<nowiki>The escape character letting insert quotation characters inside a quoted field (default is '\'). If no escape character, set to '\0' to gain some performance.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>comment</nowiki>|Description=<nowiki>The comment character indicating that a line is commented out (default is '#').</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=<nowiki>skipEmptyLines</nowiki>|Description=<nowiki>A value indicating if the reader will skip empty lines.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=<nowiki>supportsMultiline</nowiki>|Description=<nowiki>A value indicating if the reader supports multiline field.</nowiki>}}
-|Description=<nowiki>Create a new reader. Example:
+|Description=<nowiki>Create a new reader.</nowiki>}}
 |Methods=
 {{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>this[] { get; }</nowiki>|Parameters=

Cg_pham at 04:40, 12 December 2011

2011-12-12T04:40:57Z

← Older revision		Revision as of 04:40, 12 December 2011
Line 1:		Line 1:
			{{HelpFiles}}
	{{CGscriptClass_Template		{{CGscriptClass_Template
	\|Name=<nowiki>CsvReader</nowiki>		\|Name=<nowiki>CsvReader</nowiki>

Dennis: Created page with "{{CGscriptClass_Template |Name=CsvReader |Description=Represents a reader that provides fast, non-cached, forward-only access to CSV data. |Cons..."

2011-09-22T09:06:53Z

Created page with "{{CGscriptClass_Template |Name=<nowiki>CsvReader</nowiki> |Description=<nowiki>Represents a reader that provides fast, non-cached, forward-only access to CSV data.</nowiki> |Cons..."

New page

{{CGscriptClass_Template
|Name=<nowiki>CsvReader</nowiki>
|Description=<nowiki>Represents a reader that provides fast, non-cached, forward-only access to CSV data.</nowiki>
|Constructors=
{{CGscriptConstructors_Template|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>csvData</nowiki>|Description=<nowiki>The string containing the text to be parsed as csv data</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=<nowiki>hasHeaders</nowiki>|Description=<nowiki>true if field names are located on the first non commented line, otherwise, false.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>delimiter</nowiki>|Description=<nowiki>The delimiter character separating each field (default is ',').</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>quote</nowiki>|Description=<nowiki>The quotation character wrapping every field (default is ''').</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>escape</nowiki>|Description=<nowiki>The escape character letting insert quotation characters inside a quoted field (default is '\'). If no escape character, set to '\0' to gain some performance.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>comment</nowiki>|Description=<nowiki>The comment character indicating that a line is commented out (default is '#').</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=<nowiki>skipEmptyLines</nowiki>|Description=<nowiki>A value indicating if the reader will skip empty lines.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=<nowiki>supportsMultiline</nowiki>|Description=<nowiki>A value indicating if the reader supports multiline field.</nowiki>}}
|Description=<nowiki>Create a new reader. Example:
string empt = empty;
CsvReader csv = new CsvReader(csvData, true, ";", "\"", empt, empt, true, false);

number fieldCount = csv.FieldCount;
array headers = csv.Headers;
while(csv.ReadNextRecord()) {
for(number i = 0; i < fieldCount; i = i +1) {
string value = csv[i];
if (value == empty) value = "MISSING";
print(headers[i] + " = " + value);
}
print("---------");
}
</nowiki>}}
|Methods=
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>this[] { get; }</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>field</nowiki>|Description=<nowiki>The field with the specified name.</nowiki>}}
|Description=<nowiki>Gets the field with the specified name. Must have set hasHeaders to true when starting read.</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>this[] { get; }</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=number|Name=<nowiki>field</nowiki>|Description=<nowiki>The field at the specified index.</nowiki>}}
|Description=<nowiki>Gets the field at the specified index.</nowiki>}}
{{CGscriptMethods_Template|ReturnType=bool|Name=<nowiki>ReadNextRecord</nowiki>|Description=<nowiki>Reads the next record. true if a record has been successfully reads; otherwise, false.</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>ToString</nowiki>|Description=<nowiki>The string representation of the object.</nowiki>}}
|Properties=
{{CGscriptProperties_Template|ReturnType=number|Name=<nowiki>FieldCount</nowiki>|HasGetter=1|Description=<nowiki>Gets the maximum number of fields to retrieve for each record.</nowiki>}}
{{CGscriptProperties_Template|ReturnType=array|Name=<nowiki>Headers</nowiki>|HasGetter=1|Description=<nowiki>Gets the field headers.</nowiki>}}
{{CGscriptProperties_Template|ReturnType=string|Name=<nowiki>ObjectTypeName</nowiki>|HasGetter=1|Description=<nowiki>The name of the type of object.</nowiki>}}
{{CGscriptProperties_Template|ReturnType=TypeInformation|Name=<nowiki>TypeInformation</nowiki>|HasGetter=1|Description=<nowiki>Get information about this class.</nowiki>}}
}}