Permalink
Find file
a8b6232 Mar 14, 2013
156 lines (148 sloc) 5.87 KB
<div id="ddlInputText">
<span id="simplestFormattedCSV" types="int,int" valueSeparator="," headers="a,b" recordCount="1">
a,b
1,2
</span>
<span id="twoColumnFixedWidth" types="int,varchar(5)" valueSeparator="/\s\s+/" headers="Period,Result" recordCount="13">
Period Result
1 Green
1 Blue
1 Blue
1 Red
1 Blue
1 Blue
1 Blue
2 Green
2 Green
2 Green
3 Blue
2 Red
2 Red
</span>
<span id="fixedWidthDates" types="datetime,datetime,int,int,varchar(7)" valueSeparator="/\s\s+/" headers="date_due,date_paid,amount_due,amount_paid,category_type" recordCount="4">
date_due date_paid amount_due amount_paid category_type
08/12/2012 08/12/2012 500 450 Income
08/13/2012 08/17/2012 200 300 Expense
09/15/2012 09/13/2012 300 300 Income
09/17/2012 09/16/2012 100 100 Income
</span>
<span id="centeredPipes" types="varchar(1),int" valueSeparator="|" headers="L,N" recordCount="9">
L | N
-------------------
A | 1
A | 3
A | 5
B | 5
B | 7
B | 9
C | 1
C | 2
C | 3
</span>
<span id="ASCII_bordered" types="int,int,datetime,int" valueSeparator="|" headers="IdPayment,Costs_IdCost,Date,Amount" recordCount="3">
+-----------+--------------+----------+--------+
| IdPayment | Costs_IdCost | Date | Amount |
+-----------+--------------+----------+--------+
| 1 | 2 |2012/09/10| 1000 |
+-----------+--------------+----------+--------+
| 2 | 2 |2012/09/20| 3000 |
+-----------+--------------+----------+--------+
| 3 | 2 |2012/10/01| 5000 |
+-----------+--------------+----------+--------+
</span>
<span id="fixedWidthWithSpaces" types="varchar(6),varchar(13)" valueSeparator="/\s\s+/" headers="Cul 1,Cul 2" recordCount="8">
Cul 1 Cul 2
=====================
A10000 Test
A10001 Test 123
A20000 Test 1
A20001 Test 999
A30000 Test 2
A30002 Test 5555
A40000 Test 3
A40006 Test 84384848
</span>
<span id="pipedColumns" types="varchar(8),int,numeric" valueSeparator="|" headers="Scoreband,TotalNoOfPeople,AvgScore" recordCount="4">
Scoreband| TotalNoOfPeople | AvgScore
--------------------------------
-5 to 0 | 2 | -2
0 to 5 | 3 | 2
5 to 10 | 2 | 8
10 to 15 | 3 | 13.3
</span>
<span id="variableSpaceDelimited" types="varchar(3),varchar(4),varchar(5)" valueSeparator="/\s\s+/" headers="c1,c2,c3" recordCount="4">
c1 c2 c3
1A2 cat black
1G2 dog red
B11 frog green
1G2 girl red
</span>
<span id="singleSpacedColumnNames" types="int,int,int,int,int" valueSeparator="/\s+/" headers="customdata,check,service,loc,value" recordCount="6">
customdata check service loc value
101 0 0 4 4
101 0 0 3 3
101 5 4 4 3
102 0 0 1 2
102 4 4 3 3
103 0 0 4 4
</span>
<span id="stepColumnKnownForDateProblems" types="varchar(6),varchar(6),datetime,varchar(7)" valueSeparator="/\s\s+/" headers="Old,New,Time Entered,Order Number" recordCount="23">
Old New Time Entered Order Number
NULL Step 1 4/30/12 10:43 1C2014A
Step 1 Step 2 5/2/12 10:17 1C2014A
Step 2 Step 3 5/2/12 10:28 1C2014A
Step 3 Step 4 5/2/12 11:14 1C2014A
Step 4 Step 5 5/2/12 11:19 1C2014A
Step 5 Step 9 5/3/12 11:23 1C2014A
NULL Step 1 5/18/12 15:49 1C2014B
Step 1 Step 2 5/21/12 9:21 1C2014B
Step 2 Step 3 5/21/12 9:34 1C2014B
Step 3 Step 4 5/21/12 10:08 1C2014B
Step 4 Step 5 5/21/12 10:09 1C2014B
Step 5 Step 6 5/21/12 16:27 1C2014B
Step 6 Step 9 5/21/12 18:07 1C2014B
NULL Step 1 6/12/12 10:28 1C2014C
Step 1 Step 2 6/13/12 8:36 1C2014C
Step 2 Step 3 6/13/12 9:05 1C2014C
Step 3 Step 4 6/13/12 10:28 1C2014C
Step 4 Step 6 6/13/12 10:50 1C2014C
Step 6 Step 8 6/13/12 12:14 1C2014C
Step 8 Step 4 6/13/12 15:13 1C2014C
Step 4 Step 5 6/13/12 15:23 1C2014C
Step 5 Step 8 6/13/12 15:30 1C2014C
Step 8 Step 9 6/18/12 14:04 1C2014C
</span>
<span id="dateParse" types="datetime,datetime" valueSeparator="|" headers="input,output" recordCount="5">
input|output
2012-03-12|2012-03-12 00:00:00
01/02/2003|2003-01-02 00:00:00
05-Mar-1995|1995-03-05 00:00:00
April 5, 2010|2010-04-05 00:00:00
4/30/12 10:43|2012-04-30 10:43:00
</span>
<span id="withSingleQuotes" types="int,varchar(21)" valueSeparator="/\s+/" headers="CompId,CommaList" recordCount="4">
CompId CommaList
2 '122','54','90'
54 '53','76'
34 '87'
22 '98'
</span>
</div>
<!--
<span id="bracketHeaders" types="int,varchar(3),datetime" valueSeparator="/\s\s+/" headers="Serial Number,LID,Last Updated Date" recordCount="12">
[Serial Number] [LID] [Last Updated Date]
--------------------------------------
123456 AAA 09/24/2012
123456 AAA 09/23/2012
123456 AAA 09/22/2012
123456 AAA 09/21/2012
123456 BBB 09/20/2012
123456 BBB 09/19/2012
123456 AAA 09/18/2012
123456 AAA 09/17/2012
123456 AAA 09/16/2012
234567 BBB 09/24/2012
234567 BBB 09/23/2012
234567 AAA 09/22/2012
</span>
-->