Read in a file with no spaces and write one part of each line into a file

2 views (last 30 days)
Hi,
I have a data file with around 180 lines, like the following:
Date Time ,Frequency:
2019-09-11T11:43:02.782Z,9.0694850E+4
2019-09-11T11:43:07.776Z,9.0693890E+4
2019-09-11T11:43:12.779Z,9.0694460E+4
2019-09-11T11:43:17.781Z,9.0693870E+4
2019-09-11T11:43:22.775Z,9.0693370E+4
As you can see there are no spaces between date, time, and frequency determined:
How can I write a matlab script that can take this in and only give me the frequencies: so something like this:
9.0694850E+4
9.0693890E+4
9.0694460E+4
9.0693870E+4
9.0693370E+4
Thank you for your help,
  1 Comment
Walter Roberson
Walter Roberson on 12 Sep 2019
Edited: Walter Roberson on 12 Sep 2019
However if you only need the frequencies and nothing else, then a plain readtable() and then access the second variable. Or detectImportOptions and set the SelectedVariables of the options to only select the second column, and then readtable()

Sign in to comment.

Answers (1)

Jalaj Gambhir
Jalaj Gambhir on 16 Sep 2019
Hi,
You can use importdata and access the frequencies by:
c = importdata('filename',',',1);
c.data

Community Treasure Hunt

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

Start Hunting!