您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

Find text in a variable which contains texts and numbers

3 次查看（过去 30 天）

显示更早的评论

Kelly Kyriakou 2015-11-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers

评论： Kelly Kyriakou 2016-9-20

采纳的回答： Image Analyst

I read a csv file and store the data in a variable with the readtable command. This variable contains both text and numbers. How I could find the row of specific text?

采纳的回答

Image Analyst 2015-11-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#answer_201272

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#answer_201272

在 MATLAB Online 中打开

You could use ismember on the column of text, something like

loc = ismember(yourTable(:, 3), 'sometext');

if your text is in column 3. It will return the row the search text is in.

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325825

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325825

在 MATLAB Online 中打开

I tried but I got this error

Error using table/ismember (line 29)
A and B must both be tables

Image Analyst 2015-11-26

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325852

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325852

在 MATLAB Online 中打开

Right, parenthese give a column that's still a table. You need to extract the column contents using braces:

loc = ismember(yourTable{:, 3}, 'sometext');

Try that and get back to me. If that doesn't work I'll have to program up a full demo instead of tossing stuff off the top of my head. Attach your data so I can use it.

Kelly Kyriakou 2015-11-26

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325862

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325862

编辑：Stephen23 2015-11-26

This works perfectly! Thank you very much! Should I ask something more? I noticed that the stored variable doesn't have as many rows as the csv. Csv has 30770 rows with data and the stored variable has 12637. Is there any limita boust storage capacity of a variable?

Image Analyst 2015-11-26

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325870

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325870

If the original question was answered, then the questioner can click the "Accept" this answer, unless you want to wait for alternative solutions.

That shouldn't be. readtable() does not limit what it pulls from a CSV file as far as I know. Anyway, your tables are tiny. Something else must be going on. Attach your CSF file, if you can. If it's too big, then just chop off everything after 13,000 lines and try to post a truncated version.

Kelly Kyriakou 2015-11-26

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325872

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325872

output_summary.csv

I am sorry for forgeting accept the answer. I am attaching the csv which I want to read and it is produced by an other external software

Image Analyst 2015-11-26

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325880

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257660-find-text-in-a-variable-which-contains-texts-and-numbers#comment_325880

This is not a csv file as MATLAB expects it. It's line format varies quite a bit from line to line. You may have to do a line-by-line parsing of this to pull out the correct section. I just did some code for someone that did that. But it needs to be highly customized for the particular stuff in your file.

Kelly Kyriakou 2015-11-27