how to read a text file with delimiter ?
156 views (last 30 days)
Show older comments
Amr Hashem
on 25 Jul 2015
Commented: Amr Hashem
on 25 Jul 2015
I have a large text file(.txt) with delimited data , delimiter (|)
which contain numbers, texts, empty cells
i want to open it in matlab , to be something like this
each delimited in a cell
how i can do this?
Accepted Answer
Walter Roberson
on 25 Jul 2015
%read file
filestr = fileread('YourFile.txt');
%break it into lines
filebyline = regexp(filestr, '\n', 'split');
%remove empty lines
filebyline( cellfun(@isempty,filebyline) ) = [];
%split by fields
filebyfield = regexp(filebyline, '\|', 'split');
%pad out so each line has the same number of fields
numfields = cellfun(@length, filebyfield);
maxfields = max(numfields);
fieldpattern = repmat({[]}, 1, maxfields);
firstN = @(S,N) S(1:N);
filebyfield = cellfun(@(S) firstN([S,fieldpattern], maxfields), filebyfield, 'Uniform', 0);
%switch from cell vector of cell vectors into a 2D cell
fieldarray = vertcat(filebyfield{:});
Now to be consistent with your diagram, we have to convert to numeric not column by column but rather item by item: your row #8 column #3 is converted to a number even though it is the only one in the column that is converted. This is unusual and would typically lead to problems further down the road, but it is what you said you wanted.
%convert all fields to numeric
numarray = str2double(fieldarray);
%switch to cell array of numbers
outarray = num2cell(numarray);
%the places that the strings could not be converted to numbers show up as NaN
conv_failed = isnan(numarray);
%replace the failed conversions with the original text in the cells
outarray(conv_failed) = fieldarray(conv_failed);
The first part of this code, leading up to the creation of "fieldarray", can be made much much compact if the maximum number of fields per line is known in advance.
fields_per_line = 73; %for example
fmt = repmat('%s',1,fields_per_line);
fid = fopen('YourTextFile', 'rt');
filebycolumn = textscan(fid, fmt, 'Delimiter', '|');
fclose(fid);
fieldarray = horzcat(filebycolumn{:});
More Answers (0)
See Also
Categories
Find more on Text Data Preparation in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!