Filtering file from Spreadsheet based on parameters listed

[Huqs]

Hello Everyone, 

I have this VI that can open a master spreadsheet from a folder which contains CSV data files. The master spreadsheet has the filenames and their parameters listed. After opening the spreadsheet in VI multi column list box, I can double click on the filename and it will plot the data from the files. The problem is I want to filter/sort the files names based on the parameters listed on the multicolumn list box. What I mean by that is listed in this Snapshot. 

I have attached the VI with directions to operate it. I have attached the test csv file folder. You will be needing it to operate the vi. if somebody can help me to add this feature of sorting the files based on the parameters, then that would be great! thank you. 

[Gregory]

Hi Huqs,

If you want to see if your filename has a certain string in it, you can use "search/split string".

If you want to see if a certain value (like MZI 1 Voltage) falls within a range, or is exactly equal, you can use "In Range and Coerce" or "Equals?". Just parse out the value into an array that corresponds to the filenames.

[Huqs]

Hi gregoryj, 

I really liked your suggestion about search string and In range and coerce. In fact, I was tinkering with it to see how to implement to gain the function that I previously described with the screen shot. However, I am having a hard time implementing it or how to implement. Do you think you can look at my vi block diagram and see how i can implement them to have some sort of file filtration system? Thank you  

[Gregory]

Here you go

[Huqs]

Hi gregoryj, 

Thank you very much for the VI. I was trying to run it but I was sure What I was supposed to do?

[Gregory]

Once it is running you can change the value range to show you a different set of files.

[Huqs]

Oh ok, now I see. Sorry, that was a dumb question. I already was able to implement it in the actual VI.  This is Only for Ring voltage. Let's say I have MZI1, MZI2 and some other variables/columns in the spreadsheet. How can I adjust the number of numeric input (both max and min) based on the number of variables in the spreadsheet? 

[Gregory]

You will have to add the capability to select which column you want to filter by.