Hello,
I've got some huge text files look like below. I've cut a couple blocks from about 67000 blocks in the file. Basically, I would like to pick up the second line of each blocks.
Grid-ref= 1, 148
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
Grid-ref= 217, 158
2464 6009 2357 1759 559 824 377 699 1598 2311 2987 3650
4582 2779 2745 1286 1131 409 1834 2733 961 1305 1798 2571
4565 3847 2958 3990 2599 266 2266 1725 1317 4604 3376 4089
3458 4595 4535 2314 792 2538 370 3592 935 2429 1630 2962
3424 2822 2514 2949 4174 574 423 408 2530 2150 2388 4767
3729 2396 3915 1863 2792 2427 474 722 1312 1834 1752 2727
2245 3784 1928 2271 1559 312 1663 243 1539 3064 2498 3418
3804 2205 4010 2058 2049 170 1404 310 815 1052 2513 3572
2666 3392 3362 2314 1235 50 623 901 662 996 2572 2237
3846 3217 3436 865 1044 119 1411 324 889 3580 1558 1954
Grid-ref= 217, 159
2381 6044 2359 1681 627 777 455 686 1879 2053 3169 3460
4170 3020 2930 1225 1221 615 1711 2395 1002 1544 1743 2356
4109 3818 2871 3886 2254 399 1921 1465 1350 4562 3348 3463
3485 4433 4474 2537 734 2134 380 3049 1035 2363 1443 2728
3390 2443 2692 2780 3465 524 427 470 2307 1838 2502 4413
3762 2320 3775 1745 2355 1948 426 688 1165 1924 1726 2680
2012 3714 1859 2123 1445 370 1456 290 1404 2762 2446 3052
3546 1969 4162 1977 1772 147 1403 249 833 1224 2308 3447
2518 3071 3284 2243 1160 36 506 811 627 949 2386 2247
3928 2964 3049 807 1030 131 1259 366 958 3300 1331 1939
So after manipulating the file, it seems to be like this.
Grid-ref= 1, 148
3020 2820 3040 2880 1740 1360 980 990 1410 1770 2580 2630
Grid-ref= 217, 158
4582 2779 2745 1286 1131 409 1834 2733 961 1305 1798 2571
Grid-ref= 217, 159
4170 3020 2930 1225 1221 615 1711 2395 1002 1544 1743 2356
I've no clue how to work with a huge text file like this and Excel over Window definitely doesn't work.
Any idea would be much appreciate.
Best wishes,