Cell to data column

2 views (last 30 days)
Saurabh Srivastava
Saurabh Srivastava on 23 Feb 2021
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.
Saurabh Srivastava
Saurabh Srivastava on 24 Feb 2021
tried but didn't worked

Sign in to comment.

Answers (1)

KALYAN ACHARJYA on 23 Feb 2021
Edited: KALYAN ACHARJYA on 23 Feb 2021
Try with cell2table
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
Saurabh Srivastava on 24 Feb 2021
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')
% 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];
% Read next line
tline = fgetl(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);

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!