Cell to data column

Question

Saurabh Srivastava 2021-2-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/753644-cell-to-data-column

评论： Saurabh Srivastava 2021-2-24

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.

2 个评论
显示无隐藏无

Ajiket Patil 2021-2-23

Try this

tbl = rows2vars(data);

Saurabh Srivastava 2021-2-24

tried but didn't worked

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

KALYAN ACHARJYA 2021-2-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/753644-cell-to-data-column#answer_630949

编辑：KALYAN ACHARJYA 2021-2-23

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.

3 个评论
显示 1更早的评论隐藏 1更早的评论

KALYAN ACHARJYA 2021-2-24

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

Saurabh Srivastava 2021-2-24

sampleFile.txt

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);