From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting data

Solved!
Go to solution

This is the data i get  and i need to sort this data according to the date and time ..i have try few methods  but not able to solve..plz help

data  date     time

0.5 1090313 13300
1.0 1090313 23100
3.0 1090314 08150
0.5 1090314 05250
5.0 1090314 08150
0.5 1090314 05400
0.5 1090314 08150
4.5 1090314 08200
0.5 1090314 07550
2.0 1090314 08200
3.0 1090314 08250
0.5 1090314 07550
0.5 1090314 08000
3.0 1090314 08250
2.0 1090314 08300
0.5 1090314 07550
1.5 1090314 08300
3.5 1090314 08350
0.5 1090314 08000
2.5 1090314 08400
1.0 1090314 08450
1.0 1090314 08500
0.5 1090314 08550
0.5 1090314 09050
0.5 1090314 16300
3.0 1090314 08000
2.5 1090314 08050
4.0 1090314 08100
0.5 1090314 05200
2.0 1090314 08100

0 Kudos
Message 1 of 5
(2,997 Views)

I dont recognize the date/time format but here's the general procedure:

 

  • Parse the file into data and timestamp.
  • Make an array where each array element is s cluster of timestamp (first element) and data (second element).
  • Sort the array using "sort array" from the array palette. (This takes advantave of the fact that arrays of clusters are sorted according to cluster order).
  • Do whatever you want with the output. 😉
Message 2 of 5
(2,988 Views)
Solution
Accepted by topic author jeyanthi

Here's a quick solution that sorts by the date/time string. Modify as needed. (LabVIEW 8.0)

 

 

Message 3 of 5
(2,978 Views)

Can i get a small example how to do this

 

0 Kudos
Message 4 of 5
(2,977 Views)
Opps sry Thank you for the example..
0 Kudos
Message 5 of 5
(2,976 Views)