Import CSV with comma and colon

I have a CSV file I would like to import in Matlab in the following format:
1001,00:02:51,00:02:20,00:00:12,00:00:05,00:00:03,00:00:11,00:00:00 1002,00:02:51,00:02:38,00:00:05,00:00:03,00:00:04,00:00:00,00:00:00
How can I import this CSV so that both the commas and the colons are used as separators (i.e. obtain a 2x22 value matrix for this example?

Réponses (1)

Sean de Wolski
Sean de Wolski le 10 Avr 2017

0 votes

I'd just use the import tool. Hit import data and select that file or right click import on it.

2 commentaires

Victor
Victor le 10 Avr 2017
Thank you, that definitely works. However, as I have multiple CSV files I have to import I hope to make an easy script for this, is that also possible?
Sean de Wolski
Sean de Wolski le 14 Avr 2017
Under the import button there's a generate function button that does exactly this.

Connectez-vous pour commenter.

Question posée :

le 10 Avr 2017

Commenté :

le 14 Avr 2017

Community Treasure Hunt

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

Start Hunting!

Translated by