readtable csv with one column containing a field with commas
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 welcomeI’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 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 readtable, csv MATLAB Answers — New Questions