Write a script to manage data on text file.

Hi,

 I have GPS data as a text file which is shown below. Sampling rate of the data is 30 second. I would like to run text file on MATLAB and export it as a text file, too. For example, The satellite 18G has the data are -4.3652 and -4.3134 at 00:00:00UT and 00:00:30UT respectively. The same, satellite 24G has the data are -20.4441 and -20.3807 at 00:00:00UT and 00:00:30UT respectively.

 10 10 25  0  0  0.0000000  0 18G24G20G32G16G23G13G 3G11G31G 6G19  0  0  0  0  0
  0  0
  -4.3652  0
 -20.4441  0
 -12.2912  0
  -9.2496  0
 -39.1146  0
 -12.8755  0
 -14.6930  0
 -19.7318  0
  -9.5071  0
 -11.0351  0
 -40.5996  0
 999.0000  1
 999.0000  1
 999.0000  1
 999.0000  1
 999.0000  1
 999.0000  1
 999.0000  1
 10 10 25  0  0 30.0000000  0 18G24G20G32G16G23G13G 3G11G31G 6G19  0  0  0  0  0
  0  0
  -4.3134  0
 -20.3807  0
 -12.2280  0
  -9.0124  0
 -39.0715  0
 -12.8369  0
 -14.6440  0
 -19.6687  0
  -9.4681  0
 -10.9163  0
 -40.5363  0
 999.0000  1
 999.0000  1
 999.0000  1
 999.0000  1
 999.0000  1
 999.0000  1
 999.0000  1
I would like to write a MATLAB script to manage my data as shown below:
Time (UT)    18G     24G       20G     ...
00:00:00  -4.3652  -20.4441  -12.2912     ...
00:00:30  -4.3134  -20.3807  -12.2280     ...
Could you please guide me? I spent for a long time to write a script. But I can't solve my problem.

Aike

[Fangjun Jiang]

help textscan