topic Re: READ TXT FILE IN STEPS in LabVIEW

READ TXT FILE IN STEPS

Prof._Arne_Saknussemm — Tue, 16 Aug 2011 19:23:53 GMT

Hello Friends,

In the past, you've helped me a lot!

Please, I'm trying to read the variables in attached txt file. The variables appear between the lines 5187 to 5236 (49 lines). Below the line 5241 to 5290 (49 lines). After the same variables of the line 8293 to line 8342 (49 lines) and line 8347 to line 8396 (49 lines). Among the variables there is a spacing of 3106 lines. And so on!

The Knight of NI helped me a lot to solve part of the problem. His tips were very helpful!

I would like some advice to unify the variables from txt file in just a graphic. Is that possible?

Could you modify the vi.vi attached?

Thanks

Re: READ TXT FILE IN STEPS

Taki1999 — Tue, 16 Aug 2011 19:52:26 GMT

@Prof. Arne Saknussemm wrote:

...

I would like some advice to unify the variables from txt file in just a graphic. Is that possible?

...

Can you explain this a bit more?

What do you want to graph? Do you want each set as a separate series or do you want to concatenate and represent as a single time series?

Re: READ TXT FILE IN STEPS

Prof._Arne_Saknussemm — Wed, 17 Aug 2011 12:27:17 GMT

Taki1999 wrote:

Can you explain this a bit more?

What do you want to graph? Do you want each set as a separate series or do you want to concatenate and represent as a single time series?

Dear Friend Taki1999 ,

I'd like to concatenate and represent as a single time series in a single graph (steps = reading of 98 s at 98 s to 1000 s according to the txt file).

Example:

time (x-axis) x tempf 100010000 (y-axis) - tempf 100020000 (y-xis) - tempf 100030000 (y-xis) - tempf 100040000 (y-xis) - tempf 100050000 (y-xis) - tempf 100060000 (y-xis) - tempf 120010000 (y-xis) - tempf 120020000 (y-xis) - tempf 120030000 (y-xis) - tempf 120040000 (y-xis) - tempf 120050000 (y-xis) - tempf 120060000 (y-xis) ....... tempf 190010000 (y-xis) - tempf 210010000 (y-xis) - tempf 500010000 (y-xis) and so on.

Thanks!

Re: READ TXT FILE IN STEPS

Taki1999 — Wed, 17 Aug 2011 14:58:36 GMT

I'm still not entirely clear on what you're trying to do here.

You have 1 time column and 9 data columns. Is your intent to have 9 plots on a single graph with time on the x-axis?

Re: READ TXT FILE IN STEPS

Taki1999 — Wed, 17 Aug 2011 15:18:01 GMT

I think this will work if you want to see your 9 data series.

Re: READ TXT FILE IN STEPS

Prof._Arne_Saknussemm — Wed, 17 Aug 2011 17:14:03 GMT

Dear Friend Taki1999,

I have not tried your suggestion. I'll do it!

For the avoidance of doubt, I am sending you the attached file with the variables I want to read with LabVIEW. The txt file is in Excel (.xls).

Variable names are in red and the values of variables in yellow. Number of the graph in blue.

Note that along the file the variables are repeated every 98 s.
Example: time = 0 to 98 s, 100 s to 198 s, 200 s to 298 s, and so on!

Please, see all .xls file to you understand! See the file until the end!

For example, I'd like to read the variables on 2 graphs (Graph 1 and Graph 2)!

Thanks for your valuable help!

Thank you!

Re: READ TXT FILE IN STEPS

Alain_S — Wed, 17 Aug 2011 17:23:31 GMT

Is it a good assumption that each block of interrest starts with

" (K) (K) (K) (K) (K) (K) (K) (K) (K) "

If yes, then you can use the attached vi to extract each block from the file, wherever they may be in the file.

The result is a 3D array where each page is one individual block.

From that 3D array combine the pages as requested for your graphs.

Hope this helped!

Re: READ TXT FILE IN STEPS

Prof._Arne_Saknussemm — Wed, 17 Aug 2011 17:39:00 GMT

Dear Friend Alain S,

Sorry!

I can not open your suggestion (Read file.vi). SubVI's are missing:

1 - String to 1D Array_ogtk.vi;

2 - Multi-line String to Array_ogtk.vi

Could you fix it?

Thanks!

Re: READ TXT FILE IN STEPS

Alain_S — Wed, 17 Aug 2011 18:01:43 GMT

You better download the OpenG tools from this page.

Attached the missing OpenG vi's and an updated version of the code since:

a) You also need the data with only 6 (K) instead of 9

b) The last block has only 1 row of data instead of 50

Have fun... ...

Re: READ TXT FILE IN STEPS

Alain_S — Wed, 17 Aug 2011 18:04:55 GMT

It's unclear in your Excel sheet which rows belongs to Graph 1 or Graph 2 since all cells have a blue backcolor.

Please update or even better try something in LV based on the 3D array and come up with a suggestion

Re: READ TXT FILE IN STEPS

Prof._Arne_Saknussemm — Wed, 17 Aug 2011 18:41:29 GMT

Dear Friend Alain S,

I updated the xls file.

Graph 1: variables tempf 100010000 100020000 100030000 100040000 100050000 100060000 120010000 120020000 120030000 120040000 120050000 120060000 120070000 120080000 120090000 120100000 120110000 140010000

Graph 2: variables

tempf 140020000 220010000 220020000 230010000 260010000 160010000 160020000 160030000 160040000 160050000 160060000 170010000 175010000 180010000 180020000 180030000 180040000 180050000 180060000 180070000 185010000 190010000 210010000 500010000

Is it possible to present these variables in steps of 100 s (on two graphs - time (x axis) and variables (y axis))?

Thanks for the valuable help!

Re: READ TXT FILE IN STEPS

Taki1999 — Wed, 17 Aug 2011 19:10:14 GMT

I think this RELAP file format is a bit crappy 😛

My solution won't work for this since I assumed that columns = data but it looks like additional stitching which I didn't account for is necessary.

My solution will grab the first 9 columns. Additional logic can be applied to know if more columns should be added to the existing graph or whether the next block is a continuation of the time series. Think about how to do the logic and then try to do an append of the new columns.

Spend some time thinking about it and post what you end up with.

Re: READ TXT FILE IN STEPS

Alain_S — Thu, 18 Aug 2011 05:30:22 GMT

@Prof. Arne Saknussemm wrote:

Dear Friend Alain S,

I updated the xls file.

Graph 1: variables tempf 100010000 100020000 100030000 100040000 100050000 100060000 120010000 120020000 120030000 120040000 120050000 120060000 120070000 120080000 120090000 120100000 120110000 140010000

Graph 2: variables

tempf 140020000 220010000 220020000 230010000 260010000 160010000 160020000 160030000 160040000 160050000 160060000 170010000 175010000 180010000 180020000 180030000 180040000 180050000 180060000 180070000 185010000 190010000 210010000 500010000

Thanks for the update! Now it's clear for all of us.

The first graph contains the first 2 blocks of each group, that is 18 variables

The second graph contains the last 3 blocks of each group, that is 24 variables

@Prof. Arne Saknussemm wrote:

Is it possible to present these variables in steps of 100 s (on two graphs - time (x axis) and variables (y axis))?

Of course it is!

I think LabView can do everything except (maybe) baking pan cakes

Maybe a challange to all real specialists around here!

Use an XY graph, extract the pages from the 3D array and bring it all together!

I'll give you a start in the attached vi. This is NOT a good way to do it

Up to you to upgrade the code and make the second graph.

So please wire something an come back to us with your code!

Preferably in LV 8.6 version if you want me to have a look at it... ...

Re: READ TXT FILE IN STEPS

Prof._Arne_Saknussemm — Thu, 18 Aug 2011 10:16:32 GMT

Dear Friend Alain S,

I will study with care!

thanks

Re: READ TXT FILE IN STEPS

Prof._Arne_Saknussemm — Thu, 18 Aug 2011 12:16:09 GMT

Dear Friend Alain S,

See the attached VI (Read TXT file) developed in LabVIEW 8.6. I sent you the txt file again.

This reads the variables (tempf) from the lines 5187, 5241 and 5295 (see explanation in the attached VI block diagram).

Do you have any suggestions for presenting the results in just 1 graph instead of 3 graphics?

Thanks!

Re: READ TXT FILE IN STEPS

Alain_S — Thu, 18 Aug 2011 14:44:42 GMT

Something like this maybe?

Select the pages you want to show in 1 graph and let the wires do the job.

Re: READ TXT FILE IN STEPS

Prof._Arne_Saknussemm — Thu, 18 Aug 2011 15:15:17 GMT

Dear Friend Alain S,

Thanks for everything !!!

Re: READ TXT FILE IN STEPS

becidea — Wed, 25 Jan 2012 19:35:42 GMT

hi, I have almost the same problem. I want to control the temperature. Like this; I want to set the temperatures to the value that read from the file. I will prepare a txt file like;

T1 T2

300K 300K

3005K 300K

300K 300K

400K 400K

405K 400K

400K 400K

...

1000K

900K 900K

905K 900K

900K 900K

800K 800K

...

300K 300K

I want to make like this given above. each value will be contact to the LS336 temperature controller. Thanks for efford. Best.

For (i=300; i<UST_LIMIT; i = i + 100)
{
  SetTemp (H1, i);
  SetTemp (H2, i);
  WaitForTempStabilize ();
  Res = MeasureResistance ();

  SetTemp (H1, i+5);
  WaitForTempStabilize ();
  SetTemp (H1, i);
  SetTemp (H2, i);
  RecordData ();
}