Extract Data

Submit

Language is selected by the extension of the file. See the list of supported languages to know the extension of your language.

Problem

Extract required columns below "[Data]", and delete comments

Options

exec is denied

rejudge feature is enabled

now post-mortem time, all source codes will be revealed

Sample input:_

[Header]
TITLE,xxxxxxxx.dat
BYAPP,HeatCapacity,3.8.14,1.7
INFO,2.29,MASS:Sample Mass (mg)
INFO,,MASSERR:Sample Mass Error (mg)
INFO,205.58068,MOLWGHT:Formula Weight (g/mole)
INFO,7,ATOMS:Atoms per Formula Unit
INFO, Heat Capacity Option 3.8.15 Build 20,APPNAME
DATATYPE,TIME,1
DATATYPE,COMMENT,2
STARTUPAXIS, X, 8, LINEAR, AUTO
STARTUPAXIS, Y1, 10, LINEAR, AUTO
[Data]
Time Stamp (Seconds),Comment (),Puck Temp (Kelvin),System Temp (Kelvin),Sample Temp (Kelvin),Temp Rise (Kelvin),Samp HC (J/mole-K),Samp HC Err (J/mole-K),Addenda HC (uJ/K),Addenda HC Err (uJ/K)
41022684.31,CALFILE: Puck155_1.cal - Addenda #55 measured on 4/19/2017 from 1.8938 to 302.78 K
41022684.5,,300.013,299.45,302.94831,6.228222,124.32831,0.85,8872.3999,4.515
41022942.84,,300.066,299.351,302.70334,5.6470045,123.05087,0.8188,8867.6331,4.515
41023239.73,,300.00,299.29,302.69056,5.6587493,122.93617,0.8097,8867.4288,4.515
41093600.2,CALFILE: Puck155_1.cal - Addenda #56 measured on 4/19/2017 from 1.8945 to 6.97 K
41093600.45,,6.94183,7.7466,6.9761565,0.13381095,0.037976428,0.0009166,3.4680269,0.005055
41093626.0,,6.94341,7.7485,6.9772032,0.13338808,0.037621912,0.001014,3.4693201,0.005057
41093651.75,,6.944,7.7512,6.9778851,0.13327843,0.037876781,0.0009362,3.4701983,0.005059
41094250.64,,6.69529,7.3013,6.7421403,0.1326991,0.03380048,0.0008134,3.1694344,0.004567
41094277.06,,6.68978,7.2966,6.7338561,0.12852694,0.033751509,0.0007938,3.1593382,0.004551

Sample output:

Sample Temp (Kelvin),Samp HC (J/mole-K)
302.94831,124.32831
302.70334,123.05087
302.69056,122.93617
6.9761565,0.037976428
6.9772032,0.037621912
6.9778851,0.037876781
6.7421403,0.03380048
6.7338561,0.033751509

Sample input:_

[Header]
TITLE,yyyyyyyyyyy.dat
INFO,2.58,MASS:Sample Mass (mg)
INFO,,MASSERR:Sample Mass Error (mg)
INFO,255.29068,MOLWGHT:Formula Weight (g/mole)
INFO,7,ATOMS:Atoms per Formula Unit
DATATYPE,COMMENT,2
STARTUPAXIS, X, 8, LINEAR, AUTO
STARTUPAXIS, Y1, 10, LINEAR, AUTO
[Data]
Comment (),Puck Temp (Kelvin),Pressure (Torr),Sample Temp (Kelvin),Samp HC (J/mole-K),Samp HC Err (J/mole-K),Temp Squared (K^2),Samp HC/Temp (J/mole-K/K)
CALFILE: Puck169_1.cal - Addenda #37 measured on 2/8/2017 from 1.8932 to 397.37 K
,393.622,8.2E-3,397.37221,147.20678,1.065,157904.67,0.37045062
,393.68,9.3E-5,397.00524,144.97739,1.038,157613.16,0.36517753
,393.704,7.3E-7,397.05589,144.48117,1.061,157653.38,0.36388119
,353.885,4.4E-5,356.95886,136.11093,1.142,127419.63,0.3813070
,353.711,9.3E-6,356.68257,137.4826,0.8619,127222.45,0.38544804
,353.695,5.3E-6,356.62833,137.97602,0.8182,127183.7,0.38689023
,141.476,5.4E-5,142.78077,70.334446,0.3937,20386.348,0.49260448
,141.474,7.3E-5,142.78077,71.286791,0.4152,20387.562,0.49925959
,129.053,7.4E-5,130.34843,62.203934,0.571,16990.712,0.47721277
,128.801,8.6E-5,130.00725,64.007386,0.382,16901.886,0.49233704
,128.776,2.9E-6,129.95932,65.026341,0.3636,16889.426,0.50035918
,127.877,1.4E-4,129.15246,64.822317,0.364,16680.357,0.50190542
CALFILE: Puck169_1.cal - Addenda #37 measured on 2/8/2017 from 1.8932 to 6.97 K

Sample output:

Sample Temp (Kelvin),Samp HC (J/mole-K)
397.37221,147.20678
397.00524,144.97739
397.05589,144.48117
356.95886,136.11093
356.68257,137.4826
356.62833,137.97602
142.78077,70.334446
142.78077,71.286791
130.34843,62.203934
130.00725,64.007386
129.95932,65.026341
129.15246,64.822317

Sample input:_

[Header]
TITLE,zzzzzzzzzzzz.dat
BYAPP,HeatCapacity,3.8.14,1.7
INFO,1.74,MASS:Sample Mass (mg)
INFO,254.29648,MOLWGHT:Formula Weight (g/mole)
INFO,8,ATOMS:Atoms per Formula Unit
INFO,Option 3.8.14 Build 16,APPNAME
DATATYPE,TIME,1
DATATYPE,COMMENT,2
STARTUPAXIS, X, 8, LINEAR, AUTO
STARTUPAXIS, Y1, 10, LINEAR, AUTO
[Data]
Time Stamp (Seconds),Comment (),Field (Oersted),Pressure (Torr),Sample Temp (Kelvin),Temp Rise (Kelvin),Samp HC (mJ/mole-K),Time Const tau1 (seconds),Debye Temp (Kelvin),Temp Squared (K^2),Samp HC/Temp (mJ/mole-K/K)
3612663.97,CALFILE: Puck162_1.cal - Addenda #9 measured on 1/28/2016 from 1.9154 to 399.43 K
3612664.23,,0.086,9.30E-06,398.98706,6.8782791,144617.68,35.104263,790.46281,159190.67,362.46208
3612863.86,,0.086,9.30E-06,399.0596,6.8894681,144613.32,34.908293,790.67241,159248.56,362.38526
3613062.63,,0.086,9.30E-06,399.07885,6.8728909,144585.87,34.940504,791.12507,159263.93,362.299
3613635.97,,0.086,9.30E-06,395.3714,6.6874922,138070.28,33.349255,878.74405,156318.55,349.21665
3613861.63,,0.086,9.20E-06,394.51087,6.5755213,141304.54,34.657869,830.36186,155638.83,358.17653
3614094.73,,0.086,9.40E-06,394.22554,6.7417205,142458.09,35.399882,812.94636,155413.78,361.3619
3614673.13,,0.086,9.40E-06,390.31951,6.6136179,137161.34,33.961437,880.27148,152349.32,351.40784
3614901.55,,0.086,9.30E-06,389.46633,6.5219009,140455.08,35.308285,831.88956,151684.02,360.63471
3615101.22,CALFILE: Puck162_1.cal - Addenda #9 measured on 1/28/2016 from 1.9154 to 10.243 K
3615139.44,,0.086,9.40E-06,389.18447,6.6900289,141608.76,36.067504,814.78606,151464.55,363.86026
3615718.16,,0.086,9.30E-06,385.2689,6.5564621,136214.09,34.488795,881.93604,148432.13,353.55588
3615950.17,,0.086,9.40E-06,384.38718,6.4486931,139604.61,35.898774,832.97127,147753.51,363.18747
3616191.38,,0.086,9.30E-06,384.10654,6.6224835,140829.46,36.7088,815.17103,147537.83,366.64165
3616806.94,,0.086,9.10E-06,380.03346,6.5085573,136022.73,35.326231,872.54508,144425.43,357.92305
3617045.05,,0.086,9.30E-06,379.24133,6.4121752,139010.09,36.633728,830.00947,143823.98,366.54785
3617291.31,,0.086,9.40E-06,378.99289,6.5661382,140235.23,37.42106,812.56585,143635.61,370.02075
3617912.33,,0.086,9.30E-06,374.96761,6.4477408,135108.46,35.845065,873.10852,140600.71,360.32034
3618152.11,,0.086,9.40E-06,374.17086,6.3341126,138289.19,37.207783,828.66956,140003.83,369.58835
3618400.42,,0.086,9.20E-06,373.92534,6.4905575,139483.98,38.012735,811.94111,139820.16,373.02629

Sample output:

Sample Temp (Kelvin),Samp HC (mJ/mole-K)
398.98706,144617.68
399.0596,144613.32
399.07885,144585.87
395.3714,138070.28
394.51087,141304.54
394.22554,142458.09
390.31951,137161.34
389.46633,140455.08
389.18447,141608.76
385.2689,136214.09
384.38718,139604.61
384.10654,140829.46
380.03346,136022.73
379.24133,139010.09
378.99289,140235.23
374.96761,135108.46
374.17086,138289.19
373.92534,139483.98

Ranking

Ruby _

Rank	User	Size	Time	Date	Statistics
1	mitchs	46	0.0400	2017/04/24 08:26:05	0B / 22B / 22B
2	rotary-o	48	0.0359	2017/04/24 01:38:34	0B / 26B / 20B

Ruby2 _

Rank	User	Size	Time	Date	Statistics
1	mitchs	45	0.2322	2017/04/24 08:34:19	0B / 22B / 21B
2	rotary-o	47	0.2179	2017/04/24 01:38:23	0B / 26B / 19B

Perl _

Rank	User	Size	Time	Date	Statistics
1	tails	46	0.0382	2017/04/25 16:57:33	0B / 17B / 26B

Python _

Rank	User	Size	Time	Date	Statistics
1	mitchs	71	0.0919	2017/04/24 00:05:06	0B / 38B / 26B
2	rolf	86	0.0950	2017/04/23 22:39:12	0B / 39B / 45B
3	twobit	74	0.0902	2017/05/09 19:43:05	0B / 40B / 28B

Python3 _

Rank	User	Size	Time	Date	Statistics
1	mitchs	65	0.1961	2017/04/24 21:28:19	0B / 36B / 27B

JavaScript _

Rank	User	Size	Time	Date	Statistics
1	ETHproductions	125	0.0563	2017/04/27 01:38:30	0B / 66B / 57B

C _

Rank	User	Size	Time	Date	Statistics
1	tails	97	0.0366	2017/04/26 18:06:16	0B / 44B / 53B

Haskell _

Rank	User	Size	Time	Date	Statistics
1	vlad.a	190	0.0413	2017/04/27 22:14:24	0B / ?B / ?B

Java _

Rank	User	Size	Time	Date	Statistics
1	rotary-o	171	1.0506	2017/04/25 22:01:46	0B / 107B / 58B

AWK _

Rank	User	Size	Time	Date	Statistics
1	mitchs	31	0.0319	2017/04/23 14:03:09	0B / 13B / 18B
2	llhuii	31	0.0317	2017/04/23 15:56:21	0B / 13B / 18B
3	olf	76	0.0330	2017/04/23 21:13:08	0B / 29B / 46B
4	Fleur (mitchs)	30	0.0417	2021/12/23 15:44:53	0B / 13B / 17B

sed _

Rank	User	Size	Time	Date	Statistics
1	tails	54	0.0386	2017/04/25 15:58:46	0B / 9B / 41B

Bash (builtins) _

Rank	User	Size	Time	Date	Statistics
1	tails	50	0.1151	2017/04/25 15:46:15	0B / 21B / 21B
2	llhuii	51	0.0930	2017/04/28 00:38:54	0B / 23B / 23B

GolfScript _

Rank	User	Size	Time	Date	Statistics
1	mitchs	33	0.1124	2017/04/24 01:27:56	0B / 8B / 25B
2	tails	33	0.1539	2017/04/25 22:02:48	0B / 5B / 28B
3	mitchs (tails)	32	0.1497	2017/04/30 02:35:50	0B / 8B / 24B

gs2 _

Rank	User	Size	Time	Date	Statistics
1	whio	19	0.2824	2017/04/26 23:40:19	10B / 5B / 4B
2	mitchs	19	0.2987	2017/04/28 15:45:46	10B / 5B / 4B
3	tails	20	0.2643	2017/04/25 19:19:02	8B / 4B / 7B

goruby _

Rank	User	Size	Time	Date	Statistics
1	mitchs	39	0.0888	2017/04/25 07:59:53	0B / 16B / 22B
2	mitchs (rotary-o)	37	0.0940	2017/04/30 02:12:24	0B / 16B / 20B

Scala _

Rank	User	Size	Time	Date	Statistics
1	rotary-o	84	7.6829	2017/04/23 13:13:50	0B / 51B / 28B

Language Ranking_

Rank	Lang	User	Size	Score
1	gs2	whio	19	10000
2	AWK	Fleur (mitchs)	30	6333
3	GolfScript	mitchs (tails)	32	5937
4	goruby	mitchs (rotary-o)	37	5135
5	Ruby2	mitchs	45	4222
6	Ruby	mitchs	46	4130
7	Perl	tails	46	4130
8	Bash (builtins)	tails	50	3800
9	sed	tails	54	3518
10	Python3	mitchs	65	2923
11	Python	mitchs	71	2676
12	Scala	rotary-o	84	2261
13	C	tails	97	1958
14	JavaScript	ETHproductions	125	1520
15	Java	rotary-o	171	1111
16	Haskell	vlad.a	190	1000

return to the top page