MATLAB: Separating data into rows and colums

Question

hi, i need to read the data line by line ( but only acquire information which need to be tabulated into 27×27 matrix dimension for the data from begin scan1 until end scan27). I have found out that the scan of axis plane for each scanning is different, thus I'm taking that information to be the column. but I have difficulties in separating the bold data into different column and rows.

*BEGIN_SCAN_DATA*
  FORMAT=cli12                 
  FILE_CREATION_DATE=29-Mar-2010 18:01:31
  LAST_MODIFIED=29-Mar-2010 18:01:31
   *BEGIN_SCAN  1*
    TASK_NAME=ab
    GROUP_NAME=book1
    PROGRAM=123SOFTWARE
    MEAS_DATE=29-Mar-2010 17:58:52
    INPLANE_AXIS_DIR=TARGET_GUN
    CROSSPLANE_AXIS_DIR=LEFT_RIGHT
    DEPTH_AXIS_DIR=UP_DOWN
    GANTRY_UPRIGHT_POSITION=0
    GANTRY_ROTATION=CW
    SCAN_DEVICE=OCTAVIUS
    ELECTROMETER=DETECTOR_INTERFACE
    ELECTROMETER_SN=0001
    DETECTOR=OCTAVIUS_729
    ELECTROMETER_SN=0001
    SCAN_CURVETYPE=CROSSPLANE_PROFILE
    SCAN_DEPTH=0.00
    SCAN_OFFAXIS_INPLANE=-130.00
    SCAN_ANGLE=0.00
    SCAN_DIAGONAL=NOT_DIAGONAL
    MEAS_PRESET=TIME_PRESET
    MEAS_TIME=622.400
    MEAS_UNIT=GY
    CORRECTION_FACTOR=1.0000
    CROSS_CALIBRATION=1.0334
    CORRECTIONS=CROSSCALIB_CORR;
    BEGIN_DATA
       *-130.00    67.636E-03
      -120.00    83.610E-03
      -110.00    95.358E-03
      -100.00    101.60E-03
      -90.00    97.879E-03
      -80.00    114.51E-03
      -70.00    120.84E-03
      -60.00    132.72E-03
      -50.00    145.23E-03
      -40.00    141.52E-03
      -30.00    148.14E-03
      -20.00    149.73E-03
      -10.00    156.55E-03
      0.00    169.69E-03
      10.00    158.67E-03
      20.00    147.43E-03
      30.00    140.64E-03
      40.00    141.60E-03
      50.00    134.68E-03
      60.00    128.09E-03
      70.00    122.98E-03
      80.00    117.78E-03
      90.00    103.62E-03
      100.00    86.288E-03
      110.00    90.959E-03
      120.00    85.258E-03
      130.00    86.410E-03*
    END_DATA
  END_SCAN  1
  BEGIN_SCAN  2
    TASK_NAME= AB
    GROUP_NAME= BOOK1
    PROGRAM=123SOFTWARE
    MEAS_DATE=29-Mar-2010 17:58:52
    INPLANE_AXIS_DIR=TARGET_GUN
    CROSSPLANE_AXIS_DIR=LEFT_RIGHT
    DEPTH_AXIS_DIR=UP_DOWN
    GANTRY_UPRIGHT_POSITION=0
    GANTRY_ROTATION=CW
    SCAN_DEVICE=OCTAVIUS
    ELECTROMETER=DETECTOR_INTERFACE
    ELECTROMETER_SN=0001
    DETECTOR=OCTAVIUS_729
    ELECTROMETER_SN=0001
    SCAN_CURVETYPE=CROSSPLANE_PROFILE
    SCAN_DEPTH=0.00
    SCAN_OFFAXIS_INPLANE=-120.00
    SCAN_ANGLE=0.00
    SCAN_DIAGONAL=NOT_DIAGONAL
    MEAS_PRESET=TIME_PRESET
    MEAS_TIME=622.400
    MEAS_UNIT=GY
    CORRECTION_FACTOR=1.0000
    CROSS_CALIBRATION=1.0334
    CORRECTIONS=CROSSCALIB_CORR;
    BEGIN_DATA
       *-130.00    105.32E-03
      -120.00    115.35E-03
      -110.00    119.17E-03
      -100.00    140.25E-03
      -90.00    143.54E-03
      -80.00    146.85E-03
      -70.00    168.19E-03
      -60.00    173.83E-03
      -50.00    189.99E-03
      -40.00    183.19E-03
      -30.00    195.55E-03
      -20.00    200.96E-03
      -10.00    202.14E-03
      0.00    205.62E-03
      10.00    208.92E-03
      20.00    205.01E-03
      30.00    206.16E-03
      40.00    193.88E-03
      50.00    180.86E-03
      60.00    173.31E-03
      70.00    166.60E-03
      80.00    149.31E-03
      90.00    142.94E-03
      100.00    121.67E-03
      110.00    116.89E-03
      120.00    109.11E-03
      130.00    104.82E-03*
    END_DATA
  END_SCAN  2
  BEGIN_SCAN  3
    TASK_NAME= AB
    GROUP_NAME= BOOK1
    PROGRAM=123SOFTWARE
    MEAS_DATE=29-Mar-2010 17:58:52
    INPLANE_AXIS_DIR=TARGET_GUN
    CROSSPLANE_AXIS_DIR=LEFT_RIGHT
    DEPTH_AXIS_DIR=UP_DOWN
    GANTRY_UPRIGHT_POSITION=0
    GANTRY_ROTATION=CW
    SCAN_DEVICE=OCTAVIUS
    ELECTROMETER=DETECTOR_INTERFACE
    ELECTROMETER_SN=0001
    DETECTOR=OCTAVIUS_729
    ELECTROMETER_SN=0001
    SCAN_CURVETYPE=CROSSPLANE_PROFILE
    SCAN_DEPTH=0.00
    SCAN_OFFAXIS_INPLANE=-110.00
    SCAN_ANGLE=0.00
    SCAN_DIAGONAL=NOT_DIAGONAL
    MEAS_PRESET=TIME_PRESET
    MEAS_TIME=622.400
    MEAS_UNIT=GY
    CORRECTION_FACTOR=1.0000
    CROSS_CALIBRATION=1.0334
    CORRECTIONS=CROSSCALIB_CORR;
    BEGIN_DATA
      -130.00    160.76E-03
      -120.00    175.97E-03
      -110.00    171.84E-03
      -100.00    215.91E-03
      -90.00    233.59E-03
      -80.00    256.58E-03
      -70.00    282.57E-03
      -60.00    315.67E-03
      -50.00    341.93E-03
      -40.00    350.11E-03
      -30.00    359.22E-03
      -20.00    370.20E-03
      -10.00    379.43E-03
      0.00    392.72E-03
      10.00    370.24E-03
      20.00    347.00E-03
      30.00    354.97E-03
      40.00    341.63E-03
      50.00    334.92E-03
      60.00    339.05E-03
      70.00    312.09E-03
      80.00    287.94E-03
      90.00    277.34E-03
      100.00    254.44E-03
      110.00    230.88E-03
      120.00    198.08E-03
      130.00    170.71E-03
    END_DATA
  END_SCAN  3
  BEGIN_SCAN  4
    TASK_NAME= AB
    GROUP_NAME= BOOK1
    PROGRAM=123SOFTWARE
    MEAS_DATE=29-Mar-2010 17:58:52
    INPLANE_AXIS_DIR=TARGET_GUN
    CROSSPLANE_AXIS_DIR=LEFT_RIGHT
    DEPTH_AXIS_DIR=UP_DOWN
    GANTRY_UPRIGHT_POSITION=0
    GANTRY_ROTATION=CW
    SCAN_DEVICE=OCTAVIUS
    ELECTROMETER=DETECTOR_INTERFACE
    ELECTROMETER_SN=0001
    DETECTOR=OCTAVIUS_729
    ELECTROMETER_SN=0001
    SCAN_CURVETYPE=CROSSPLANE_PROFILE
    SCAN_DEPTH=0.00
    SCAN_OFFAXIS_INPLANE=-100.00
    SCAN_ANGLE=0.00
    SCAN_DIAGONAL=NOT_DIAGONAL
    MEAS_PRESET=TIME_PRESET
    MEAS_TIME=622.400
    MEAS_UNIT=GY
    CORRECTION_FACTOR=1.0000
    CROSS_CALIBRATION=1.0334
    CORRECTIONS=CROSSCALIB_CORR;
    BEGIN_DATA
      -130.00    210.79E-03
      -120.00    240.34E-03
      -110.00    268.68E-03
      -100.00    322.87E-03
      -90.00    391.69E-03
      -80.00    488.84E-03
      -70.00    637.43E-03
      -60.00    792.51E-03
      -50.00    994.49E-03
      -40.00    1.1081E+00
      -30.00    1.1951E+00
      -20.00    1.2875E+00
      -10.00    1.3686E+00
      0.00    1.4037E+00
      10.00    1.3813E+00
      20.00    1.3195E+00
      30.00    1.3597E+00
      40.00    1.3392E+00
      50.00    1.2933E+00
      60.00    1.1869E+00
      70.00    896.74E-03
      80.00    575.54E-03
      90.00    435.85E-03
      100.00    367.78E-03
      110.00    323.30E-03
      120.00    291.61E-03
      130.00    262.03E-03
    END_DATA
  END_SCAN  4
  BEGIN_SCAN  5
    TASK_NAME= AB
    GROUP_NAME= BOOK1
    PROGRAM=123SOFTWARE
    MEAS_DATE=29-Mar-2010 17:58:52
    INPLANE_AXIS_DIR=TARGET_GUN
    CROSSPLANE_AXIS_DIR=LEFT_RIGHT
    DEPTH_AXIS_DIR=UP_DOWN
    GANTRY_UPRIGHT_POSITION=0
    GANTRY_ROTATION=CW
    SCAN_DEVICE=OCTAVIUS
    ELECTROMETER=DETECTOR_INTERFACE
    ELECTROMETER_SN=0001
    DETECTOR=OCTAVIUS_729
    ELECTROMETER_SN=0001
    SCAN_CURVETYPE=CROSSPLANE_PROFILE
    SCAN_DEPTH=0.00
    SCAN_OFFAXIS_INPLANE=-90.00
    SCAN_ANGLE=0.00
    SCAN_DIAGONAL=NOT_DIAGONAL
    MEAS_PRESET=TIME_PRESET
    MEAS_TIME=622.400
    MEAS_UNIT=GY
    CORRECTION_FACTOR=1.0000
    CROSS_CALIBRATION=1.0334
    CORRECTIONS=CROSSCALIB_CORR;
    BEGIN_DATA
      -130.00    256.85E-03
      -120.00    313.07E-03
      -110.00    463.32E-03
      -100.00    711.00E-03
      -90.00    944.77E-03
      -80.00    1.3764E+00
      -70.00    1.6090E+00
      -60.00    1.7774E+00
      -50.00    1.8591E+00
      -40.00    1.8673E+00
      -30.00    1.8844E+00
      -20.00    1.8832E+00
      -10.00    1.8966E+00
      0.00    1.9295E+00
      10.00    1.8771E+00
      20.00    1.9483E+00
      30.00    1.9791E+00
      40.00    1.9730E+00
      50.00    1.9912E+00
      60.00    1.9616E+00
      70.00    1.8626E+00
      80.00    1.3593E+00
      90.00    928.88E-03
      100.00    639.81E-03
      110.00    442.38E-03
      120.00    365.98E-03
      130.00    311.41E-03
    END_DATA
  END_SCAN  5
  BEGIN_SCAN  6
    TASK_NAME= AB
    GROUP_NAME= BOOK1
    PROGRAM=123SOFTWARE
    MEAS_DATE=29-Mar-2010 17:58:52
    INPLANE_AXIS_DIR=TARGET_GUN
    CROSSPLANE_AXIS_DIR=LEFT_RIGHT
    DEPTH_AXIS_DIR=UP_DOWN
    GANTRY_UPRIGHT_POSITION=0
    GANTRY_ROTATION=CW
    SCAN_DEVICE=OCTAVIUS
    ELECTROMETER=DETECTOR_INTERFACE
    ELECTROMETER_SN=0001
    DETECTOR=OCTAVIUS_729
    ELECTROMETER_SN=0001
    SCAN_CURVETYPE=CROSSPLANE_PROFILE
    SCAN_DEPTH=0.00
    SCAN_OFFAXIS_INPLANE=-80.00
    SCAN_ANGLE=0.00
    SCAN_DIAGONAL=NOT_DIAGONAL
    MEAS_PRESET=TIME_PRESET
    MEAS_TIME=622.400
    MEAS_UNIT=GY
    CORRECTION_FACTOR=1.0000
    CROSS_CALIBRATION=1.0334
    CORRECTIONS=CROSSCALIB_CORR;
    BEGIN_DATA
      -130.00    294.83E-03
      -120.00    422.61E-03
      -110.00    666.40E-03
      -100.00    927.94E-03
      -90.00    1.2322E+00
      -80.00    1.5608E+00
      -70.00    1.7429E+00
      -60.00    1.8687E+00
      -50.00    1.8849E+00
      -40.00    1.8676E+00
      -30.00    1.8742E+00
      -20.00    1.8885E+00
      -10.00    1.8911E+00
      0.00    1.9827E+00
      10.00    1.8718E+00
      20.00    1.9127E+00
      30.00    1.9429E+00
      40.00    1.9749E+00
      50.00    1.9888E+00
      60.00    1.9897E+00
      70.00    1.9105E+00
      80.00    1.5991E+00
      90.00    1.1195E+00
      100.00    879.09E-03
      110.00    631.69E-03
      120.00    473.58E-03
      130.00    351.63E-03
    END_DATA
  END_SCAN  6
  BEGIN_SCAN  7
    TASK_NAME= AB
    GROUP_NAME= BOOK1
    PROGRAM=123SOFTWARE
    MEAS_DATE=29-Mar-2010 17:58:52
    INPLANE_AXIS_DIR=TARGET_GUN
    CROSSPLANE_AXIS_DIR=LEFT_RIGHT
    DEPTH_AXIS_DIR=UP_DOWN
    GANTRY_UPRIGHT_POSITION=0
    GANTRY_ROTATION=CW
    SCAN_DEVICE=OCTAVIUS
    ELECTROMETER=DETECTOR_INTERFACE
    ELECTROMETER_SN=0001
    DETECTOR=OCTAVIUS_729
    ELECTROMETER_SN=0001
    SCAN_CURVETYPE=CROSSPLANE_PROFILE
    SCAN_DEPTH=0.00
    SCAN_OFFAXIS_INPLANE=-70.00
    SCAN_ANGLE=0.00
    SCAN_DIAGONAL=NOT_DIAGONAL
    MEAS_PRESET=TIME_PRESET
    MEAS_TIME=622.400
    MEAS_UNIT=GY
    CORRECTION_FACTOR=1.0000
    CROSS_CALIBRATION=1.0334
    CORRECTIONS=CROSSCALIB_CORR;
    BEGIN_DATA
      -130.00    394.91E-03
      -120.00    582.53E-03
      -110.00    826.78E-03
      -100.00    991.34E-03
      -90.00    1.2543E+00
      -80.00    1.5508E+00
      -70.00    1.7145E+00
      -60.00    1.8012E+00
      -50.00    1.8497E+00
      -40.00    1.8396E+00
      -30.00    1.8246E+00
      -20.00    1.8426E+00
      -10.00    1.8657E+00
      0.00    1.8826E+00
      10.00    1.7767E+00
      20.00    1.8820E+00
      30.00    1.9161E+00
      40.00    1.9425E+00
      50.00    1.9555E+00
      60.00    1.9483E+00
      70.00    1.8889E+00
      80.00    1.6724E+00
      90.00    1.2760E+00
      100.00    1.0631E+00
      110.00    831.59E-03
      120.00    638.47E-03
      130.00    516.47E-03
    END_DATA
  END_SCAN  7
  BEGIN_SCAN  8
    TASK_NAME= AB
    GROUP_NAME= BOOK1
    PROGRAM=123SOFTWARE
    MEAS_DATE=29-Mar-2010 17:58:52
    INPLANE_AXIS_DIR=TARGET_GUN
    CROSSPLANE_AXIS_DIR=LEFT_RIGHT
    DEPTH_AXIS_DIR=UP_DOWN
    GANTRY_UPRIGHT_POSITION=0

            

            
            
            

    

        

	
    

        
Best Answer
    

    

								

								
f= fopen('d20160413.txt'); 
c = textscan(f,'%s','delimiter','\n'); 
fclose(f)
c = c{:};
[~,~,~,v] = regexp(c,'\d*\.\d+E[\-\+]\d{2}')
out = reshape(str2double([v{:}]),27,[]);
						    
						
		
    
        

    

Related Solutions
MATLAB: How to defining date format

								

								
d_vect = datetime('2007.01.01. 01', 'Format', 'yyyy.MM.DD. HH');
						    
						
MATLAB: Delete the header from a scientific data

								

								
Hello Aliaa,
It's good that your files are plain text, you can open them in MATLAB easily.
You need to write a program, consisted of a for loop which has the same number as the number of your files 365.
It's also good that you know all the headers are from line 1 to 21, as you can simply get rid of them.
Hopefully, your files have some sort of order in their names, like cnb1,cnb2,...,cnb365 or any other order.
lets say cnb1 is the first file we want to edit.
use fopen to open cnb1
use fopen to open another file in a different folder with the same name cnb1 (this is going to be the new file without the header)
use getl to read one line at a time
create a while loop to read and write line by line to the files, while should stop when the result of fgetl is empty
make a counter for lines in the while loop
make an if so when the number of counter is smaller than 21 it won't write to the new cnb1 file.
that's all!
finally outside the while loop close both files using fclose
see these in MATLAB documentation
doc fopen
doc fclose
doc fgetl
doc while
doc for
Oh! in the main for loop before you open cnb1 cnb2 and ... you need to create their names lets assume
for i = 1 :10
 filename = ['C:\myFolder\cnb',num2str(i),'.txt'];
Although your files are not txt it's just an assumption.
Give it a try, and let us know if you have prob.
I'll attach a similar file where I edited a txt file, just to see how you can open files, read them and ...
Good Luck!
						    
						
        
        

            
            
            
Related Question
Char convertion into double. please help!!!
Get in Order respond when using “eig” command
Datetick error message when displaying dates on the x-axis
        
    

Answer 1

f= fopen('d20160413.txt'); 
c = textscan(f,'%s','delimiter','\n'); 
fclose(f)
c = c{:};
[~,~,~,v] = regexp(c,'\d*\.\d+E[\-\+]\d{2}')
out = reshape(str2double([v{:}]),27,[]);