readtable csv with one column containing a field with commas
    6 visualizaciones (últimos 30 días)
  
       Mostrar comentarios más antiguos
    
    Derek
 el 25 de Jun. de 2024
  
    
    
    
    
    Comentada: Derek
 el 25 de Jun. de 2024
            I'm reading a CSV file with the command:
readtable(Logic_file, 'ReadVariableNames', true, 'Format', '%d%d%f%s%s%d%s','EmptyValue',0);
My problem is that the supplier of input file has change the last column from a string to something like this:  
{'string1', 'string2'}
readtable() is seeing the commas in this {} field and trying to make more columns.  I want readtable to treat whatever is in the {...} as a single field not to be broken up.  Any ideas would be welcome
0 comentarios
Respuesta aceptada
  Walter Roberson
      
      
 el 25 de Jun. de 2024
        readtable(Logic_file, 'ReadVariableNames', true, 'Format', '%d%d%f%s%s%d%[^\n]','EmptyValue',0);
This will handle columns with and without {}
Más respuestas (0)
Ver también
Categorías
				Más información sobre Structures en Help Center y File Exchange.
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

