Column Options

Specifying columns with column nodes optional.
Column headers can be in embedded in the first row of data, be auto-generated as numbers, or omitted entirely when returning an array.

column nodes have 2 fields:

	<transform-to-json>
		<column name=[String] type=[DataType]></column>
		<!-- zero or more columns -->
	</transform-to-json>

DataType

Valid values are Number, Boolean, and String; as well as Number?, Integer?, and String?
The values Number, Boolean, and String are well optimized, and expect clean conversion. Any unconvertable data will result in an NaN for that field.

Number? will try its best to convert to a number, by stripping non-numeric characters.
Integer? same as Number?, but will also round to the nearest integer.
String? will trim whitespace from the beginning and end.

Input	No Type	Boolean	String	String?	Number	Number?	Integer?
empty	{{demo1_0}}	{{demo1_1}}	{{demo1_2}}	{{demo1_3}}	{{demo1_4}}	{{demo1_5}}	{{demo1_6}}
space	{{demo2_0}}	{{demo2_1}}	{{demo2_2}}	{{demo2_3}}	{{demo2_4}}	{{demo2_5}}	{{demo2_6}}
null	{{demo3_0}}	{{demo3_1}}	{{demo3_2}}	{{demo3_3}}	{{demo3_4}}	{{demo3_5}}	{{demo3_6}}
ABCD	{{demo4_0}}	{{demo4_1}}	{{demo4_2}}	{{demo4_3}}	{{demo4_4}}	{{demo4_5}}	{{demo4_6}}
ABCD EF _	{{demo5_0}}	{{demo5_1}}	{{demo5_2}}	{{demo5_3}}	{{demo5_4}}	{{demo5_5}}	{{demo5_6}}
10000	{{demo6_0}}	{{demo6_1}}	{{demo6_2}}	{{demo6_3}}	{{demo6_4}}	{{demo6_5}}	{{demo6_6}}
9.45	{{demo7_0}}	{{demo7_1}}	{{demo7_2}}	{{demo7_3}}	{{demo7_4}}	{{demo7_5}}	{{demo7_6}}
9.55	{{demo8_0}}	{{demo8_1}}	{{demo8_2}}	{{demo8_3}}	{{demo8_4}}	{{demo8_5}}	{{demo8_6}}
-1e5	{{demo9_0}}	{{demo9_1}}	{{demo9_2}}	{{demo9_3}}	{{demo9_4}}	{{demo9_5}}	{{demo9_6}}
-1e-10	{{demo10_0}}	{{demo10_1}}	{{demo10_2}}	{{demo10_3}}	{{demo10_4}}	{{demo10_5}}	{{demo10_6}}
$ 100,000s00	{{demo11_0}}	{{demo11_1}}	{{demo11_2}}	{{demo11_3}}	{{demo11_4}}	{{demo11_5}}	{{demo11_6}}
true	{{demo12_0}}	{{demo12_1}}	{{demo12_2}}	{{demo12_3}}	{{demo12_4}}	{{demo12_5}}	{{demo12_6}}
false	{{demo13_0}}	{{demo13_1}}	{{demo13_2}}	{{demo13_3}}	{{demo13_4}}	{{demo13_5}}	{{demo13_6}}
1	{{demo14_0}}	{{demo14_1}}	{{demo14_2}}	{{demo14_3}}	{{demo14_4}}	{{demo14_5}}	{{demo14_6}}
0	{{demo15_0}}	{{demo15_1}}	{{demo15_2}}	{{demo15_3}}	{{demo15_4}}	{{demo15_5}}	{{demo15_6}}