Could you please provide script to perform process described below. Many thanks in advance

In the 1.5 million line .txt file (only first 57 lines shown below)

Goal is to delete all columns except column four. Then move this data to the left.

I need to then save this file in .txt format so it can be opened (I.E. fopen) in a future matlab script

Example: The first column needs to look like this when script is performed on it.

0.06247

0.03747

0.03747

0.03747

...and so on

Here's the file

0.000000	0.06259	-0.06223	0.06247	0.99601	0.03158	0.00018	22.10	22.15	0
0.040001	0.03756	-0.04984	0.03747	0.99622	0.03219	0.00018	22.07	22.15	0
0.080000	0.03756	-0.04984	0.03747	0.99562	0.03260	0.00059	22.07	22.15	0
0.120000	0.03756	-0.04984	0.03747	0.99602	0.03239	-0.00002	22.07	22.15	0
0.160000	0.05005	-0.03727	0.03747	0.99581	0.03219	-0.00002	22.07	22.15	0
0.200000	0.05006	-0.04977	0.03748	0.99622	0.03198	0.00018	22.03	22.15	0
0.240000	0.06256	-0.04971	0.03748	0.99643	0.03219	-0.00003	22.10	22.15	0
0.280000	0.06256	-0.04971	0.03748	0.99622	0.03219	0.00038	22.03	22.15	0
0.320000	0.03757	-0.04984	0.04997	0.99643	0.03260	-0.00023	22.10	22.15	0
0.360001	0.06256	-0.04971	0.03748	0.99581	0.03219	-0.00002	22.07	22.15	0
0.400000	0.03757	-0.04984	0.04997	0.99602	0.03260	-0.00023	22.03	22.15	0
0.440000	0.03756	-0.04984	0.03747	0.99582	0.03239	0.00018	22.03	22.15	0
0.480000	0.05007	-0.04978	0.04998	0.99561	0.03219	-0.00002	22.07	22.15	0
0.520000	0.05005	-0.03727	0.03749	0.99602	0.03178	-0.00003	22.10	22.15	0
0.560000	0.05006	-0.04977	0.03748	0.99602	0.03260	0.00018	22.07	22.15	0
0.600000	0.06257	-0.04972	0.04998	0.99622	0.03158	-0.00023	22.07	22.15	0
0.640000	0.06256	-0.04971	0.03748	0.99541	0.03219	-0.00002	22.03	22.15	0
0.680000	0.05007	-0.04978	0.04998	0.99582	0.03239	-0.00002	22.10	22.16	0
0.720000	0.03757	-0.03734	0.04998	0.99601	0.03137	0.00017	22.07	22.16	0
0.760000	0.05007	-0.04978	0.04998	0.99622	0.03178	0.00058	22.07	22.15	0
0.800000	0.05007	-0.04978	0.04998	0.99623	0.03280	0.00059	22.07	22.16	0
0.840000	0.06257	-0.04972	0.04998	0.99622	0.03178	0.00018	22.10	22.16	0
0.880000	0.05007	-0.04978	0.04998	0.99643	0.03219	0.00018	22.07	22.17	0
0.920000	0.05007	-0.04978	0.04998	0.99642	0.03178	0.00017	22.10	22.17	0
0.960001	0.06257	-0.04972	0.04998	0.99622	0.03219	0.00018	22.07	22.17	0
1.000001	0.05007	-0.04978	0.04998	0.99602	0.03219	0.00038	22.07	22.17	0
1.040000	0.05007	-0.04978	0.04998	0.99622	0.03219	0.00038	22.10	22.17	0
1.080000	0.06257	-0.04972	0.04998	0.99581	0.03199	-0.00003	22.07	22.17	0
1.120001	0.03757	-0.04984	0.04997	0.99602	0.03178	0.00018	22.13	22.17	0
1.160000	0.03757	-0.04984	0.04997	0.99643	0.03198	0.00018	22.10	22.17	0
1.200001	0.03756	-0.04984	0.03747	0.99581	0.03198	0.00018	22.07	22.17	0
1.240000	0.03757	-0.04984	0.04997	0.99622	0.03219	-0.00043	22.07	22.17	0
1.280000	0.05007	-0.04978	0.04998	0.99643	0.03239	0.00018	22.07	22.17	0
1.320000	0.06256	-0.04971	0.03748	0.99582	0.03260	0.00018	22.10	22.18	0
1.360000	0.05006	-0.04977	0.03748	0.99622	0.03198	0.00018	22.13	22.18	0
1.400000	0.06256	-0.06221	0.03747	0.99582	0.03239	0.00100	22.07	22.18	0
1.440000	0.05006	-0.04977	0.03748	0.99602	0.03219	0.00018	22.10	22.17	0
1.480001	0.05007	-0.04978	0.04998	0.99581	0.03219	-0.00002	22.17	22.17	0
1.520000	0.06257	-0.04972	0.04998	0.99582	0.03219	0.00099	22.10	22.17	0
1.560000	0.05006	-0.04977	0.03748	0.99602	0.03239	0.00018	22.07	22.17	0
1.600001	0.03756	-0.04984	0.03747	0.99622	0.03198	-0.00003	22.13	22.17	0
1.640000	0.05009	-0.03729	0.06249	0.99581	0.03198	0.00038	22.13	22.17	0
1.680000	0.05007	-0.04978	0.04998	0.99663	0.03239	0.00018	22.10	22.17	0
1.720001	0.05007	-0.04978	0.04998	0.99581	0.03198	0.00018	22.13	22.17	0
1.760000	0.05005	-0.03727	0.03749	0.99602	0.03219	0.00079	22.13	22.17	0
1.800000	0.05007	-0.04978	0.04998	0.99623	0.03260	-0.00002	22.07	22.17	0
1.840000	0.06255	-0.03721	0.03750	0.99561	0.03219	0.00038	22.10	22.17	0
1.880001	0.05007	-0.04978	0.04998	0.99602	0.03260	0.00018	22.13	22.17	0
1.920000	0.06257	-0.03722	0.05000	0.99602	0.03219	0.00018	22.13	22.18	0
1.960000	0.06257	-0.04972	0.04998	0.99622	0.03178	0.00058	22.13	22.18	0
2.000001	0.05007	-0.04978	0.04998	0.99622	0.03219	-0.00023	22.10	22.18	0
2.040000	0.05007	-0.04978	0.04998	0.99663	0.03178	-0.00023	22.17	22.18	0
2.080000	0.05006	-0.04977	0.03748	0.99622	0.03198	0.00038	22.13	22.18	0
2.120000	0.05007	-0.04978	0.04998	0.99602	0.03219	0.00059	22.10	22.18	0
2.160000	0.06256	-0.04971	0.03748	0.99622	0.03239	-0.00023	22.10	22.18	0
2.200000	0.05005	-0.03727	0.03749	0.99602	0.03219	-0.00023	22.07	22.18	0
2.240001	0.05007	-0.04978	0.04998	0.99643	0.03198	0.00038	22.07	22.1

Answer 1

[Duane Melvin]

data_file=load('SCH63_11_17_22_backup_workingq.txt'); 
j=[2];           %define column number
colm_data=data_file(:,j); % Column data for further use

writematrix(colm_data, 'GZ.txt');

Answer 2

[Torsten]

A = rand(7)

A = 7×7

0.9251 0.7288 0.0045 0.7998 0.9367 0.6610 0.3797 0.0627 0.6351 0.9058 0.5269 0.9427 0.0369 0.8074 0.2940 0.0416 0.8010 0.1406 0.7628 0.1347 0.1148 0.1904 0.5255 0.6585 0.9014 0.0839 0.3026 0.5115 0.0925 0.3903 0.6269 0.6232 0.7953 0.5247 0.0124 0.6448 0.5859 0.7592 0.3045 0.2755 0.5507 0.1936 0.4970 0.2017 0.9420 0.7136 0.4950 0.4853 0.7443

A = A(:,4)

A = 7×1

0.7998 0.5269 0.1406 0.9014 0.6232 0.3045 0.7136

writematrix(A, 'A.txt')

[Duane Melvin]

Thanks so much

[Duane Melvin]

The answer did not work but this one did. This script below worked. I found it removes all columns except the column number in j=[] in this case, column 2 data is preserved

then it writes a new .txt file named GZ with column 2 moved over to the far left. Perfect

data_file=load('SCH63_11_17_22_backup_workingq.txt'); 
j=[2];           %define column number
colm_data=data_file(:,j); % Column data for further use

writematrix(colm_data, 'GZ.txt');