csvRestart export data to zero or a few days ago???

2 views (last 30 days)
I now have over 20000 csv lines in my export file. However, 95% of those lines were used during trial and error and are not real. I know that a running total of lines is necessary for my yearly limit license, but how cn I avoid exporting the data before yesterday?..... as the current data is the only data I want anymore.
  2 Comments
pragnan nadimatla
pragnan nadimatla on 7 Jul 2023
As per my understanding you want to export CSV by avoiding data upto certain time as it is unnecessary.One approach is to convert timestamp column to datetime array using datetime function.Find the reference datetime of yesterday and find the index of first row in table with timestamp of yesterday.You can then filter the original CSV to include the rows with valid timestamps i.e starting from yesterday.Use indexing to Filter Data from Yesterday.
Please refer the following documentation on how to use datetime:
Christopher Stapels
Christopher Stapels on 28 Sep 2023
Edited: Christopher Stapels on 28 Sep 2023
@Shore Are you talking about ThingSpeak data? If so, you can use the API to adjust the date range of desired points.

Sign in to comment.

Answers (0)

Categories

Find more on Visualize Data in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!