readtable csv with one column containing a field with commas

1 vue (au cours des 30 derniers jours)
Derek
Derek le 25 Juin 2024
Commenté : Derek le 25 Juin 2024
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

Réponse acceptée

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

Plus de réponses (0)

Catégories

En savoir plus sur Structures dans Help Center et File Exchange

Produits


Version

R2024a

Community Treasure Hunt

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

Start Hunting!

Translated by