Find string ends with xls or xlsx
2 views (last 30 days)
Show older comments
chlor thanks
on 13 Jul 2016
Commented: chlor thanks
on 14 Jul 2016
I have a char array of strings (each string is a file name) and I would like to find out the strings that ends with xls or xlsx. I know that strcmp can be used only if to compare the first few characters, which is the opposite of what I intent to do---compare the last few characters.
What should I do in this case? Thank you.
0 Comments
Accepted Answer
Azzi Abdelmalek
on 13 Jul 2016
Edited: Azzi Abdelmalek
on 13 Jul 2016
str='abc.xlsx xls.m df.xls er.doc sd.xls'
out=regexp(str,'\S+\.xlsx?\>','match')
6 Comments
Guillaume
on 14 Jul 2016
I would use this simpler regex:
regexp(str, '\.xlsx?$', 'match', 'once')
Matches '.xls', followed by an optional 'x', followed by the end of the string.
More Answers (1)
Star Strider
on 13 Jul 2016
The findstr function may do what you want:
fn = 'filename.xlsx';
xls_pos = findstr(fn,'xls')
xls_pos =
10
So if ‘xls_pos’ (in this example) is not empty, the string contains ‘xls’ or ‘xlsx’.
2 Comments
See Also
Categories
Find more on String Parsing 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!