error in reading csv file

5 views (last 30 days)
Ayman Mounir
Ayman Mounir on 14 Mar 2021
Answered: Jan on 14 Mar 2021
Hello everyone,
I have a problem ( as shown in the figure) in reading csv file using readtable function. the coulmon of the time in csv file is written as 455.33.22 it means 4553322 seconds.
Thanks in advance.
Ragrds,
Ayman

Answers (1)

Jan
Jan on 14 Mar 2021
Use the 'Format' option of readtable to import the time as string. Then remove the dots with strrep and convert the rest to a number.

Categories

Find more on Data Import and Analysis in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!