read array size and based on Array Size read rows (columns) one by one

[Igor Dzombic]

OK, I have one text file to read and extract the Values to table. The Problem is, in ParserLG.vi, I readout Array Size (Row Size (96)), after this I hav to read one by one everi single of them and serch for a Value in Row for device (Parsing) for a specific Time (Date-Time, (Date-Time is a Number of Row)). However, every time I execute this VI its readin the last Value insted of one after anather :(. Pleas HELP ME!!!

 You`ll find all VI`s and sorce (text) File in Attachment

THX

Igor  

[smercurio_fc]

I can't quite understand what your VI is doing, and I can't run it because several subVIs are missing. Let's skip that for the moment, and let's simply look at the text file. What are you trying to find in the text file? What are the independent variables, and what are the dependent variables? Your description wasn't all that clear.

[Igor Dzombic]

I have a Values for a every 15 min. (96 Values for a Day). These Values are Sorted under Device (LGxxxxxxxx). I need a for every Device Value for every 15 min.

[smercurio_fc]

I'm not sure I completely understand, but it sounds like you just want to pull off the column corresponding to a specific device. That's just an index/search/subset operation:

 

Message Edited by smercurio_fc on 04-03-2009 09:33 AM

[Dennis_Knutson]

If all that you need is the values in columns 3,4,5, then that code you have written is the most convoluted program I have seen in a very long time. Start with the code below to get each column and then do whatever you want with it.

[Igor Dzombic]

no, it`s not all, I have some time 1 and some time  20 Devices! The LGxxxxxxx is used as Parsingcriteria and every single Value have to be sorted by Time (first column after Date). The Table is based on Date and some time I have the Values, for exempel, for Date 14:00, 14:30, 17:15,..... and so on. I should sort them in Table by Time to.

[smercurio_fc]

I'm sorry, but I am simply not understanding what you want to do.  There is no time column. The date and time are in the same column. What is that picture supposed to show and how is it related to your text file? I also feel as if you're not telling us the whole story here.

If I had to take another guess it appears that what you want to do, in essence, is to transpose your text file.  Each device that is in the text file becomes a row. Presumably, the device name goes in column 1. Then, you want to get the value for the time at 15 minutes. That time may or may not be in the text file (is this true?). If it is, it gets placed in that device's row in the "00:15" column. I can't translate the column headers - looks like either German or Dutch, so I don't know what those other columns are supposed to be. Is this correct?

[Igor Dzombic]

you are right, the Names in columns are not important (its German), but you are right... i need Value for Device (every device get one row) under right Time in Table (if yyyy.mm.dd 00:15:00  15.0000-> in row for device under 00:15 shulld stay 15,00)

THX

[smercurio_fc]

OK, that's a little clearer. Is it possible for a certain time to not appear in the text file? Is the assumption that all of the times have the same date?

[Igor Dzombic]

Yes, it is possible for a certain time to NOT appear in the File and last Line (00:00:00) do not have same Date, but this (Date) is not a big problem