Readtable() confused by quotation marks? Matlab 2019a
    8 Ansichten (letzte 30 Tage)
  
       Ältere Kommentare anzeigen
    
    Michael
 am 26 Aug. 2019
  
    
    
    
    
    Beantwortet: Michael
 am 26 Aug. 2019
            Hello.
When executing
t = readtable('myfile.txt','FileType','text','Delimiter','|');
I am receiving this error
Error using readtable (line 216)
Reading failed at line 52223. All lines of a text
file must have the same number of delimiters. Line
52223 has 5 delimiters, while preceding lines have 9.
Note: readtable detected the following parameters:
'HeaderLines', 0, 'ReadVariableNames', false,
'Format', '%f%q%f%f%f%q%q%f%f%f'
I confirmed that the error is thrown, not because of the delimiters but because of a quotation mark.  I confirmed this by removing the quotation marks from the file. Is there a way around this without altering the file itself?
Thank You,
Michael
1 Kommentar
Akzeptierte Antwort
  Jeremy Hughes
    
 am 26 Aug. 2019
        opts = detectImportOptions('myfile.txt','FileType','text','Delimiter','|')
T = readtable('myfile.txt',opts)
0 Kommentare
Weitere Antworten (1)
Siehe auch
Kategorien
				Mehr zu Text Files finden Sie in Help Center und File Exchange
			
	Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!


