Readtable() confused by quotation marks? Matlab 2019a
    8 visualizaciones (últimos 30 días)
  
       Mostrar comentarios más antiguos
    
    Michael
 el 26 de Ag. de 2019
  
    
    
    
    
    Respondida: Michael
 el 26 de Ag. de 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
Respuesta aceptada
  Jeremy Hughes
    
 el 26 de Ag. de 2019
        opts = detectImportOptions('myfile.txt','FileType','text','Delimiter','|')
T = readtable('myfile.txt',opts)
0 comentarios
Más respuestas (1)
Ver también
Categorías
				Más información sobre Text Files en Help Center y File Exchange.
			
	Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!


