Import CSV with comma and colon

4 views (last 30 days)
Victor
Victor on 10 Apr 2017
Commented: Sean de Wolski on 14 Apr 2017
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?

Answers (1)

Sean de Wolski
Sean de Wolski on 10 Apr 2017
I'd just use the import tool. Hit import data and select that file or right click import on it.
  2 Comments
Victor
Victor on 10 Apr 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 on 14 Apr 2017
Under the import button there's a generate function button that does exactly this.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!