Excel search

[rayclout]

This is as far as I can get with the meta search. It's ugly and it's not working, but I think I'm almost there.

Any suggestions?

Thanks guys

[kekin]

---

What u have posted does not seem to be ok. Please clearly explain ur requirement with respect to excel you have attached earlier so that we can help u better. Give some specific examples.

Although ur inverters are down but u can make excel of ur own & explain ur requirement more clearly.

[Rkll · Accepted solution]

Hey,

So from what I have gathered.. You get the data from the Sheet and you want to search for multiple Meta Names.

Each Meta Name can appear multiple times from different sources. The data you want is in the final row of the column.

The VI i have attached serves my interpretation of your problem. Hope it helps!

- Rkll

[aeastet]

Hi Rkll,

I made one small change to your code to make it not write an empty string if nothing is found.

[rayclout]

RkII and aeastet

Perfect........that is exactly what I am looking for.

If you don't mind I'll go over your code and work out the operation (a good way for me to learn) so that I will know how to do this in future.

I will give the solution to RkII, as his post come in first, but if it's possible, I'm going to give you both kudos.

Thanks again guys

Ray

p.s. Kekin, I can't explain it any simpler than I have, but thanks for your interest

[rayclout]

Guys

I've just given the vi a good workout, and found a couple of things wrong.

1. It's not finding ALL the meta names in the list.

2. It's not finding duplicate meta names on the same row.

The second point is probably because my xlsx file doesn't have any multiple names, but future files will definitely have them (see earlier posts)

So, I'm really back to where I started. I was able to do a search for the meta names easily enough, but the assistance I really need is how to do a search for multiple entries for the SAME meta name if it occurs once or many more times in the SAME row....AND....output the column index responding to their location.

So, any further ideas?

Thanks guys

R

[rayclout]

This is what a row of metas could possibly look like

[Rkll]

Hey,

Problem was the lack of a shift register in the middle for loop left the data being overwritten when the Meta name was being found multiple times.

The solution is to use a shift register to continually append multiple finds into a 2D array and then append that to the main 2D array.

Regards,

Rkll

[rayclout]

Hello RKII

Could you save that as LV 2009 version.

I'd like to open it for a look-see

Regards

Ray

[Rkll]

Sure...