Re : Re: Table row switch

[Cheese11]

Hi there,

I'm working with a system that has a log-file.

A small part of the file is added as attachment.

What I want to do is to scan the file and put the latest date (30-03-2010) at the top.

So the dates have to go from newest to oldest date.

Then I want to put the data into a string and put it in a table.

How can I do this in Labview?

Thanks

[MikeS81]

Hi Cheese11,

you can use the "Read From Spreadsheet File.vi" to get your data into a table. With "Index Array", "Sort" and "Reverse" can you modifiy it for your needs.

Mike

[Cheese11]

Hey Mike,

I'm doing that to put it in a table.

But when I use the "Reverse"-block, the columns will get reversed, but not the rows.

And with "Sort" it is the problem that I need a 1D Array.

In my file you can see dat the Array consists out of more columns.

So are there any more solutions or do you mean something else?

Greetz

[MikeS81]

Hi Cheese11,

see the attached image.

Mike

[Cheese11]

Mike,

What is the name of that 2 ABC-blocks, can't find them.

Thanks

[JB]

Bundle and Unbundle

You will find them here : Functions palette >>  Cluster, Class & Variant

[Cheese11]

Mike,

I'm very sorry, but now I can't find the 2nd block, the block after the "Read Spreadsheet String" block.

Greets

[MikeS81 · Accepted solution]

Hi Cheese11,

from left to right.

"Read From Spreadsheet File"

"Index Array"

"For Loop" with "bundle"

"Sort 1D Array"

"Reverse Array"

"For Loop" with "unbundle"

"Array of String indicator"

🙂

Mike

Message Edited by MikeS81 on 03-30-2010 10:57 AM

[Cheese11]

Hey Mike,

Thanks for your help!!!

The vi is doing what I want.

Greetz