Cell to data column

I have data which is in cell. I want to convert them into table like we do in excel text2column. Hereby, I am attaching a screenshot of the data. I want entire cell array in tabulated form.

[Ajiket Patil]

Try this

tbl = rows2vars(data);

[Saurabh Srivastava]

tried but didn't worked

Answer 1

[KALYAN ACHARJYA]

Try with cell2table

https://in.mathworks.com/help/matlab/ref/cell2table.html

Note that the single coulmn cell data having numeric and non numeric data types. If this is not resolved, please attach a sample data file.

[Saurabh Srivastava]

Already tried but didnot worked. :(

[KALYAN ACHARJYA]

Please share the sample data (not screenshot), and can you show us code what you have tried with table?

[Saurabh Srivastava]

Hi Kalyan,

Actually I am reading SINEX file. I am sharing the sample data file and corresponding code. If you can sugeest me some better way to read the data, it will be a great help.

Here is the code and file.

% Reading sinex file
fname = 'sampleFile.txt';
fid = fopen(fname)
if fid == -1
   disp(['Couldn''t find the file: ', fname])
   error('File does not exist')
end

%%
% Finding the breaking point in data file from where I need to read and
% seperate the data.
tline = fgetl(fid);
lineCounter = 0;            % Number of linee readed in data file
patternCounter = 0;         % Counting that how many time certain pattern comes in data file
patArray = [];              % At what line the patter comes, this will hel in seperating different data
while ischar(tline)
    % disp(tline)
    lineCounter = lineCounter + 1;
    if strcmp(tline, '*-------------------------------------------------------------------------------')
        patternCounter = patternCounter+1;
        patArray = [patArray; lineCounter];
    end
    % Read next line
    tline = fgetl(fid);    
end
fclose(fid);

%% 
% Slicing and restoring data in desired format
All = textread(fname,'%s','delimiter', '\n');
dataName = All{patArray(4)+1};
data  = All(patArray(4)+3:patArray(5)-2);