Clear Filters
Clear Filters

readtable csv with one column containing a field with commas

20 views (last 30 days)
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

Accepted Answer

Walter Roberson
Walter Roberson on 25 Jun 2024 at 19:46
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)

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Products


Release

R2024a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!