readtable csv with one column containing a field with commas

1 次查看（过去 30 天）
Derek
Derek 2024-6-25
评论： Derek 2024-6-25
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

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2024-6-25
readtable(Logic_file, 'ReadVariableNames', true, 'Format', '%d%d%f%s%s%d%[^\n]','EmptyValue',0);
This will handle columns with and without {}

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

产品


版本

R2024a

Community Treasure Hunt

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

Start Hunting!

Translated by