Need to find rows with specific strings
4 ビュー (過去 30 日間)
古いコメントを表示
I am pulling data in from an excel file and need to check which rows contain a specific string of text
data =7150x1 string
I need to know which rows contain 'xyz'
strfind() returns Search term must be a text or pattern scalar
Contains returns just a 0
2 件のコメント
Image Analyst
2024 年 1 月 18 日
If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:
Dyuman Joshi
2024 年 1 月 20 日
編集済み: Dyuman Joshi
2024 年 1 月 22 日
As mentioned, unless we have the file to test what happens, it is difficult to suggest anything.
Please share the file you are working with. Use the paperclip button to attach.
Edit -
"Contains returns just a 0 "
@Charles, Could you elaborate on this? Does it return just a 0? Or all 7150 values are 0?
回答 (1 件)
Walter Roberson
2024 年 1 月 20 日
編集済み: Walter Roberson
2024 年 1 月 20 日
mask = contains(data, 'what you are looking for');
selected_data = data(mask);
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!