Str2Mat - Revision history

Gordon.dye: /* Parameters */

2022-04-13T13:02:57Z

Parameters

← Older revision		Revision as of 13:02, 13 April 2022
Line 12:		Line 12:
	"Delimiter$" is a string containing the character in the string variable which will be used to separate it into items to be placed in the array. For example, a comma ",". In 4.3 Delimiter can be an array.		"Delimiter$" is a string containing the character in the string variable which will be used to separate it into items to be placed in the array. For example, a comma ",". In 4.3 Delimiter can be an array.

	"Quotes:Trim" is an optional parameter which handles quotes within the string variable. Quotation marks can suppress the recognition of separators so that any delimiter (such as a comma) that occurs between the specified quotes will not split the data into separate array elements. Quote-type can be Q, QUOTES, ('), or ("), and is case insensitive. Q and QUOTES means that BR will recognize from the data which type of quotes (double or single) will be recognized by examining the first nonblank character. Q and QUOTES also means the enveloping quote characters will be stripped off of the data placed into the receiving array. The trim flags can be :LTRM , :TRIM or :RTRM , and denote post processing of extracted elements. The leading colon is only present when quote-type is specified (as of 4.3).		"Quotes:Trim" is an optional parameter which handles quotes within the string variable. Quotation marks can suppress the recognition of separators so that any delimiter (such as a comma) that occurs between the specified quotes will not split the data into separate array elements. Quote-type can be Q, QUOTES, ('), or ("), and is case insensitive. Q and QUOTES means that BR will recognize from the data which type of quotes (double or single) will be recognized by examining the first nonblank character. Q and QUOTES also means the enveloping quote characters will be stripped off of the data placed into the receiving array. The trim flags can be :LTRM , :TRIM or :RTRM , and denote post processing of extracted elements. In essence these indicate that leading and/or trailing blanks should be stripped from each resultant array element. The leading colon is only present when quote-type is specified (as of 4.3).

	When examining str$ left to right, the first character (and the first character after each separator) is checked to see if is either (') or ("). If the first character is a quote, then it suppresses the recognition of separators until quotation processing is deactivated by another occurrence of the leading quote. The string is copied until it ends or until an odd number of successive occurrences of the governing quote type is encountered. During this processing, two adjacent occurrences of the governing quote character denote a single embedded occurrence of the quote character and is disregarded as a quote deactivator.		When examining str$ left to right, the first character (and the first character after each separator) is checked to see if is either (') or ("). If the first character is a quote, then it suppresses the recognition of separators until quotation processing is deactivated by another occurrence of the leading quote. The string is copied until it ends or until an odd number of successive occurrences of the governing quote type is encountered. During this processing, two adjacent occurrences of the governing quote character denote a single embedded occurrence of the quote character and is disregarded as a quote deactivator.

Gordon.dye: /* Parameters */

2018-09-21T22:05:22Z

Parameters

← Older revision		Revision as of 22:05, 21 September 2018
Line 12:		Line 12:
	"Delimiter$" is a string containing the character in the string variable which will be used to separate it into items to be placed in the array. For example, a comma ",". In 4.3 Delimiter can be an array.		"Delimiter$" is a string containing the character in the string variable which will be used to separate it into items to be placed in the array. For example, a comma ",". In 4.3 Delimiter can be an array.

	"Quotes:Trim" is an optional parameter which handles quotes within the string variable. Quotation marks can suppress the recognition of separators so that any delimiter (such as ~~commas~~) that ~~occur within~~ the specified quotes will not split the data into separate array elements. Quote-type can be Q, QUOTES, ('), or ("), and is case insensitive. Q and QUOTES means that double ~~quotes~~ will be ~~used~~. The trim flags can be :LTRM , :TRIM or :RTRM , and denote post processing of extracted elements. The leading colon is only present when quote-type is specified (as of 4.3).		"Quotes:Trim" is an optional parameter which handles quotes within the string variable. Quotation marks can suppress the recognition of separators so that any delimiter (such as a comma) that occurs between the specified quotes will not split the data into separate array elements. Quote-type can be Q, QUOTES, ('), or ("), and is case insensitive. Q and QUOTES means that BR will recognize from the data which type of quotes (double or single) will be recognized by examining the first nonblank character. Q and QUOTES also means the enveloping quote characters will be stripped off of the data placed into the receiving array. The trim flags can be :LTRM , :TRIM or :RTRM , and denote post processing of extracted elements. The leading colon is only present when quote-type is specified (as of 4.3).

	When examining str$ left to right, the first character (and the first character after each separator) is checked to see if is either (') or ("). If the character is a quote, then it suppresses the recognition of separators until quotation processing is deactivated by another quote.		When examining str$ left to right, the first character (and the first character after each separator) is checked to see if is either (') or ("). If the first character is a quote, then it suppresses the recognition of separators until quotation processing is deactivated by another occurrence of the leading quote. The string is copied until it ends or until an odd number of successive occurrences of the governing quote type is encountered. During this processing, two adjacent occurrences of the governing quote character denote a single embedded occurrence of the quote character and is disregarded as a quote deactivator.

	The string is copied until it ends or until an odd number of successive occurrences of the governing quote type is encountered. During this processing, two adjacent occurrences of the governing quote character denote an embedded occurrence of the quote character and is disregarded as a quote deactivator.

	===Defaults===		===Defaults===

Gordon.dye: /* XML Parsing Enhancements */

2018-09-21T21:28:41Z

XML Parsing Enhancements

← Older revision		Revision as of 21:28, 21 September 2018
Line 110:		Line 110:
	This makes the parsing of XML a bit more convenient. The following XML sample shows how the function will parse the data		This makes the parsing of XML a bit more convenient. The following XML sample shows how the function will parse the data

			Data:
	<XML>		<XML>
	<NODE>		<NODE>
Line 116:		Line 117:
	</XML>		</XML>

			Results:
	<XML		<XML
	<NODE		<NODE

Gordon.dye: /* Defaults */

2018-09-21T21:19:29Z

Defaults

← Older revision		Revision as of 21:19, 21 September 2018
Line 19:		Line 19:

	===Defaults===		===Defaults===
	1. The default delimiter searches for the following combinations of [[line feed]] and [[carriage return]] characters:		Actually, the delimiter parameter is also optional in a sense. But practically speaking it is mandatory.

			The default delimiter searches for the following combinations of [[line feed]] and [[carriage return]] characters:

	*[[line feed]] [[carriage return]]		*[[line feed]] [[carriage return]]
Line 25:		Line 27:
	*[[line feed]]		*[[line feed]]
	*[[carriage return]]		*[[carriage return]]

			This enables multiple CSV rows to be contained in a single string.

	===Further Explanation===		===Further Explanation===

John: it's quotes: not quote:

2018-07-12T11:48:32Z

it's quotes: not quote:

← Older revision		Revision as of 11:48, 12 July 2018
Line 12:		Line 12:
	"Delimiter$" is a string containing the character in the string variable which will be used to separate it into items to be placed in the array. For example, a comma ",". In 4.3 Delimiter can be an array.		"Delimiter$" is a string containing the character in the string variable which will be used to separate it into items to be placed in the array. For example, a comma ",". In 4.3 Delimiter can be an array.

	"~~Quote~~:Trim" is an optional parameter which handles quotes within the string variable. Quotation marks can suppress the recognition of separators so that any delimiter (such as commas) that occur within the specified quotes will not split the data into separate array elements. Quote-type can be Q, QUOTES, ('), or ("), and is case insensitive. Q and QUOTES means that double quotes will be used. The trim flags can be :LTRM , :TRIM or :RTRM , and denote post processing of extracted elements. The leading colon is only present when quote-type is specified (as of 4.3).		"Quotes:Trim" is an optional parameter which handles quotes within the string variable. Quotation marks can suppress the recognition of separators so that any delimiter (such as commas) that occur within the specified quotes will not split the data into separate array elements. Quote-type can be Q, QUOTES, ('), or ("), and is case insensitive. Q and QUOTES means that double quotes will be used. The trim flags can be :LTRM , :TRIM or :RTRM , and denote post processing of extracted elements. The leading colon is only present when quote-type is specified (as of 4.3).

	When examining str$ left to right, the first character (and the first character after each separator) is checked to see if is either (') or ("). If the character is a quote, then it suppresses the recognition of separators until quotation processing is deactivated by another quote.		When examining str$ left to right, the first character (and the first character after each separator) is checked to see if is either (') or ("). If the character is a quote, then it suppresses the recognition of separators until quotation processing is deactivated by another quote.

Laura: /* Reading a CSV file */

2015-07-13T23:46:02Z

Reading a CSV file

← Older revision		Revision as of 23:46, 13 July 2015
Line 182:		Line 182:
	! This Sample Program Reads A Csv and puts it into two arrays, which could easily be written into a BR data file.		! This Sample Program Reads A Csv and puts it into two arrays, which could easily be written into a BR data file.
	dim Wholepiece$10000, codelist$(1)256, description$(1)256, code$(1), nextline$256		dim Wholepiece$10000, codelist$(1)256, description$(1)256, code$(1), nextline$256

	open #1: "name=hcodeexport.csv, recl=500",display,input		open #1: "name=hcodeexport.csv, recl=500",display,input

	mat Code$(0)		mat Code$(0)
	mat Description$(0)		mat Description$(0)
	let delim$=","		let delim$=","

	do while file(1)=0		do while file(1)=0
	linput #1: nextline$ eof ignore		linput #1: nextline$ eof ignore
Line 194:		Line 194:
	! at this point we have 1 line of the CSV file in NextLine$		! at this point we have 1 line of the CSV file in NextLine$
	let str2mat(nextline$,mat codelist$,delim$,"Q:trim")		let str2mat(nextline$,mat codelist$,delim$,"Q:trim")

	! at this point we have mat CodeList$ sized 2 with each element in it		! at this point we have mat CodeList$ sized 2 with each element in it

	! lets do something useful, lets build them together into 2 arrays		! lets do something useful, lets build them together into 2 arrays
	index=udim(mat code$) +1 ! find new position in the arrays		index=udim(mat code$) +1 ! find new position in the arrays
	mat Code$(index) ! Make the arrays bigger		mat Code$(index) ! Make the arrays bigger
	mat Description$(index)		mat Description$(index)

	! Put the stuff we found into the new arrays		! Put the stuff we found into the new arrays
	let code$(index)=codelist$(1)		let code$(index)=codelist$(1)
Line 207:		Line 207:
	end if		end if
	loop		loop

	! print mat code$		! print mat code$
	! print mat description$		! print mat description$

Laura at 23:45, 13 July 2015

2015-07-13T23:45:21Z

← Older revision		Revision as of 23:45, 13 July 2015
Line 185:		Line 185:
	open #1: "name=hcodeexport.csv, recl=500",display,input		open #1: "name=hcodeexport.csv, recl=500",display,input

	mat ~~Codelist~~$(0)		mat Code$(0)
	mat Description$(0)		mat Description$(0)
	let delim$=","		let delim$=","

Laura at 12:55, 12 July 2015

2015-07-12T12:55:50Z

← Older revision		Revision as of 12:55, 12 July 2015
Line 3:		Line 3:
	STR2MAT(<string variable>, MAT <array name>, [MAT] <delimiter$>, [<quote-type:trim>])		STR2MAT(<string variable>, MAT <array name>, [MAT] <delimiter$>, [<quote-type:trim>])

	[[image:str2mat.png]]		[[image:str2mat.png\|800px]]

	===Parameters===		===Parameters===

Laura at 12:53, 12 July 2015

2015-07-12T12:53:10Z

← Older revision		Revision as of 12:53, 12 July 2015
Line 2:		Line 2:

	STR2MAT(<string variable>, MAT <array name>, [MAT] <delimiter$>, [<quote-type:trim>])		STR2MAT(<string variable>, MAT <array name>, [MAT] <delimiter$>, [<quote-type:trim>])

			[[image:str2mat.png]]

	===Parameters===		===Parameters===

Laura: /* Quote Processing Examples */

2015-07-12T02:19:12Z

Quote Processing Examples

← Older revision		Revision as of 02:19, 12 July 2015
Line 135:		Line 135:
	===Quote Processing Examples===		===Quote Processing Examples===
	The following chart demonstrates how data in the source string is handled if * and , are delimiters:		The following chart demonstrates how data in the source string is handled if * and , are delimiters:
	{\|~~class~~=~~wikitable~~		{\|border="2" style="border-collapse:collapse;"
			\|-style="background:#a5c7ff;"
	!String		!String
	!Final Array Element		!Final Array Element