Readtable from a text file with multiple delimiter

2020 11 2
1 个回答
回答已采纳
更新时间：2020 11 7
10 次查看（30 天）

0 个投票

Hello,
I have a text file with column delimited by tab , but the string containing the variable name has as a delimiter simple multiple space.
Is there a way to specify that the delimiter of the variable name row is different from the rest of the file ?

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

Rik
Rik 2020-11-2
I don't have the actual answer, but you could parse them separately.

请先登录，再进行评论。

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

 采纳的回答

Rishik Ramena
Rishik Ramena 2020-11-6

0 个投票

You can try using readcell in the following way. I'm not sure how your data looks like. If this does not help in your data, you can try importing the data interactively using the Import Tool.
table = readcell('rows.txt', 'Delimiter', ' ')
% 2×5 cell array
%
% {'peter'} {'pan'} {[10]} {[ 2]} {[30]}
% {'john' } {'doe'} {[30]} {[50]} {[60]}
col_1 = table(:, 1);
col_2 = table(:, 2);
name = strcat(col_1, {' '}, col_2)
% name =
%
% 2×1 cell array
%
% {'peter pan'}
% {'john doe' }

4 个评论
显示 2更早的评论 隐藏 2更早的评论

andrea
andrea 2020-11-6
Thank you, it helped. Do you know if there is a function that returns the number of the lines where there is an occurrence of a given expression? I mean I want to find on which lines the word "hello" is found in a text
Rik
Rik 2020-11-6
Are you interested in the line number in your file, or in your variable?
Rik
Rik 2020-11-7
You can get my readfile function from the FEX. If you are using R2017a or later, you can also get it through the AddOn-manager. That will read your file to a cell array (1 cell per line), after which you can loop through the lines and use something like contains.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2020b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by