How to find strings in an excel file?

2013 4 8
1 个回答
回答已采纳
4 次查看（30 天）

0 个投票

I want to find all colons in an excel file
colons = findstr(char, ':');
colons shows up empty. why is that?

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

 采纳的回答

Diana
Diana 2013-4-9

0 个投票

Thanks for your reply
Yes, I did.
I also tried
colons = findstr(string, ':');
Any idea of what could be wrong?

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

Yao Li
Yao Li 2013-4-9
编辑：Yao Li 2013-4-9
try
find(strcmp(':',string ))
The string here should be a cell matrix loaded from the Excel file. This function returns the location of the colons.
Diana
Diana 2013-4-11
I had to change to
find(strcmp(':',char)) so it would work
But it is still returning empty
Yao Li
Yao Li 2013-4-11
sorry, I think it is not good to use string as the name of the variable.
find(strcmp(':',text_load_from_Excel ))
text_load_from_Excel is a cell type variable loaded from the Excel file
Diana
Diana 2013-4-15
No worries. Can you explain to me what a cell type variable is?

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by