readtable csv with one column containing a field with commas
    6 views (last 30 days)
  
       Show older comments
    
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 Comments
Accepted Answer
  Walter Roberson
      
      
 on 25 Jun 2024
        readtable(Logic_file, 'ReadVariableNames', true, 'Format', '%d%d%f%s%s%d%[^\n]','EmptyValue',0);
This will handle columns with and without {}
More Answers (0)
See Also
Categories
				Find more on Structures 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!
