Open Excel file and filter 2d string array by column in labview

[Tiannut]

Hello LabVIEW expert,

I am new LabVIEW learning.

I have create one LabVIEW program for my project.

My project is to verify test equipment on test station compare to master list Excel file.

1) Load Excel master list file --> Done

2) Select station ID --> On going

3) Show equipment station list

4) Scan bar-code label on the actual equipment by using bar-code scanner

5) Compare equipment station info and then show result (Pass/Fail)

Right now, I able to load Excel file and get 2D array data string type.

How to filter 2D string array (filter) by select column "where used" ?

I have attached file Excel master list.

Thanks in advance.

Best Regards,

Tiannut

[ABCPrograms]

OpenG is a very useful set of VI used by 'millions' of LabVIEW programmers.

One of the VI's in there is 'filter array'

You certainly want to check out OpenG 🙂

[Tiannut]

Hi Bjorn,

Thanks for your giving solution.

Unfortuntately, there is error happen after installed OpenG into my PC.

It's not compatible!

Any other solution?

Thanks & Regards,

Tianrawit N.

[ABCPrograms]

What did the error say?

An other solution is bringing your array into a for loop, check the values from the array for your filter you want to apply.

Add a shiftregister to the for loop and initialise it with an empty array

If its a match, add the element to the array in your shift register.  If its not a match, skip the value and go to the next iteration

[Tiannut]

The VI Package Manager program shows error message

"This package is not compatiblw with your operating system or any LabVIEW version installed on your computer?

I've got your idea for the other solution.

But I am not sure how to write that VI code.

Please help me.