MATLAB: I have a Table in MATLAB. In one colum, lots of texts are seperated in comma. I wish to delimate those in seperate colums.

delimatetable

I have a Table in MATLAB. In one colum, lots of texts are seperated in comma. I wish to delimate those in seperate colums.

clc
clear
raw=readtable('Service.xlsx');
r=0;
raw_problem=raw.Expert_Found_Problems;
P=height(raw);
for i=1:1:P
   PROBLEMS=raw_problem{i,1};
   C = strsplit(PROBLEMS,',')
   r=r+1
     T(r,:)=table(C)
end

Best Answer

It's not clear what you want as an output since for each row you're going to get a different number of elements after the split. Maybe:

raw.Expert_Found_Problems = cellfun(@(s) strsplit(s, ','), raw.Expert_Found_Problems, 'UniformOutput', false);

which creates a column cell array of cell arrays.

Related Solutions

MATLAB: Delimate Table and Rewrite it

table() applied to the results of strsplit is probably giving you a table with one variable and three rows.

You need to take special steps when the input is a vector because there is an ambiguity over whether to create a table with one row and several variables, or a table with several rows and one variable.

table(C{1},C{2},C{3}, 'VariableNames', {'Problem1', 'Problem2', 'Problem3'})

MATLAB: Import an Excel File

I think that I am starting to see what you did, and it is not something that we generally do actually, hence the misunderstanding.

Using the Import Data tool (and not the function), you loaded the content of an Excel workbook. Then you asked the tool to generate a function for you. Now the tool doesn't generate a function with the data. It generates a function for loading the data from the same Excel file that you initially opened, to allow you to bypass this step the next time that you want to read the data. What this function takes as an argument is the path/name of the original Excel file. So if you opened file MyData.xlsx with the Import Data tool, the correct call for loading the data from the same file is

 data = importfile( 'MyData.xlsx' ) ;

 data = importfile( 'C:\ ... whatever path ..\MyData.xlsx' ) ;

Now we never do all this with the import data tool. Instead we call directly the XLSREAD function (you can check that the importfile script does that too):

 [~, data] = xlsread( 'MyData.xlsx' ) ;

where the first output of XLSREAD is a numeric array that we discard with ~ because you have no numeric data in your workbook, and the second contains the text.

If you don't want to read the original Excel file next time (because it is slow), you can now save the cell array data into a MAT-File using SAVE, and load it using LOAD (you'll have to read the doc to see how it works).

Apparently, you want to split each line into words, which you can do with STRSPLIT. You can try on the content of the first cell of data:

 strsplit( data{1}, ' ' )

and see that you have a cell array of words. Then you can think about implementing e.g. a loop over all cells of data and store the words in another cell array for example.

Best Answer

Related Solutions

MATLAB: Delimate Table and Rewrite it

MATLAB: Import an Excel File

Related Question