Format of xlsread output
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hello all,
A simple question: if I were to read an excel workbook's cells, one of them which contained a literal string in this format:
{ISM_PKExteriorScanReq = NTI_PKExteriorScanReq}
[ISM_PEnable && ISM_PKExteriorScanReq==2]
{SCH_Fob_Found=x;
SCH_Finished=ISTRUE;
SCH_callTEA=ISTRUE;}
The output for the particular cell would like identical to what it read. Is there any special characters or something that is hidden in this text though (such as newlines)? So, for example, if there were hidden characters, using a regexp function:
match = regexp(text, regexptranslate('escape', text), 'match');
match would be an empty cell array. In my case, match is an empty cell array.
0 Kommentare
Antworten (1)
Walter Roberson
am 17 Mai 2017
If that is a single cell, then Yes, there would have to be characters other than the obvious, or else the output formatting would be different.
You can find the unexpected characters using
badchar_mask = ~isstrprop(text, 'print');
text(badchar_mask) + 0
2 Kommentare
Walter Roberson
am 18 Mai 2017
Are you indicating that the output of text(badchar_mask) + 0 was empty?
Could you post double() of each of the strings?
Siehe auch
Kategorien
Mehr zu Characters and Strings finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!