Cell to data column

2021 2 23
1 个回答
更新时间：2021 2 24
7 次查看（30 天）

0 个投票

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.

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

回答（1 个）

KALYAN ACHARJYA
KALYAN ACHARJYA 2021-2-23
编辑：KALYAN ACHARJYA 2021-2-23

0 个投票

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更早的评论

Saurabh Srivastava
Saurabh Srivastava 2021-2-24
Already tried but didnot worked. :(
KALYAN ACHARJYA
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
Saurabh Srivastava 2021-2-24
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);

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by