Clear Filters
Clear Filters

How do i change a ISO 861 Date that is beeing immported as categorical to a double or similar?

2 views (last 30 days)
Hey,
I am helping someone with this, after two days of googling and searching i am kinda lost.
I have a CSV, similar to the snipet i uploaded(the real file is 8GB), and i am trying to get rid of the categorical format. My Workflow as of rn, import data, select delimited, and so on and soforth and choose column vectors. With that, i can do all the other manipulations as i please, but i need the "time" do finish the job.
At this point i am out of ideas and i do not know where to continue searching.
THanks in advance

Answers (2)

Cameron
Cameron on 5 Jan 2023
All I did was use the readtable function and it seemed to work fine. Is there something else that I'm missing?
importTable = readtable('Measurement 47 .csv');
NewDateTime = datetime(extractBefore(strrep(importTable.Time,"T"," "),"."));

Siddharth Bhutiya
Siddharth Bhutiya on 26 Jan 2023
You could use detectImportOptions + readtable to do this. detectImportOptions would allow you to specifiy what the data type of the imported variable should be. Link to doc: detectImportOptions

Products


Release

R2022b

Community Treasure Hunt

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

Start Hunting!