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 ExchangeStructures についてさらに検索

タグ

製品


リリース

R2024a

Community Treasure Hunt

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

Start Hunting!

Translated by