Search for a specific string from an excel sheet

[amt1981]

Thanks Ray i really appreciate it!!

[James_W]

---

amt1981 wrote:

Hey Guys,

first i really wanna thank you for your help and ray for the vi examples you provided me, even though i didnt use them but they gave lots of insight to know where to put my thinking and solve my problem.

Now i have one final favor to ask of you, i attached a vi which my excel sheet for the license plate i extract and then for most it finds it, and then i made another search from within this excel file in order to extract some data concerning the car owner, what i am facing is that some times even though the license plates are found in the database, my program seems not to read the license plate and issues me an error message, and/or it finds the license and then at the index where the string was found it can't seem to extract data, or sometimes for a specific string it just extract few data not all i require.

So please if you could find me where the problem is i would really appreciate it.

I suspect that maybe because the Read Excel.vi that i used is openning and closing my excel sheet many times that it is causing my program not to work properly as it should.

Thanks again

Amin

---

Questions:

1) How big is the real database

2) How often is it updated

3) is it feasible to open the database once only every [insert time period], copy the data into an FGV and when you know you have a good data set, work on that, rather than keep accessing the Excel file? (see 1 & 2) - this technique would eliminate access errors!

James

[Ray.R]

Do you still have problems with the database?

If so, can you post your code and some database entries?

[amt1981]

Hey Ray,

Q:1) How big is the real database?

A:Well i would prefer it to be dynamic but for the exposition purposes and because it is a prototype, i made to be an excel database of 150 rows.

Q:2) How often is it updated?

A: well it would be updated each 3 or 4 months.

Q:3) is it feasible to open the database once only every [insert time period], copy the data into an FGV and when you know you have a good data set, work on that, rather than keep accessing the Excel file? (see 1 & 2) - this technique would eliminate access errors!

A: Well it could be a good idea, because while asking about what is happening everyone told me that the problems and errors i am facing are caused by the multiple openning and closing of the excel file by the labview program.

But to be honest i have no idea of how to create an FGV and how to work with it and actually programming it in LabVIEW.

So if you could help with that it would make my program more robust and as you said less prone to access errors.

I really thank you again Ray.

Amin

[Ray.R]

FGV:  Functional Global Variable.  You could do a search on Action Engine.  I will look for Ben's nugget on the subject.

[James_W]

It's really simple

here's one I knocked up in LV2009 - took 2mins from scratch, not much documentation, but enough that you can play with it, see how it works and finish it off.

James

[amt1981]

Hey James,

Could you please save this FGV vi into LabVIEW 8.6 version and repost it! I have the 8.6 version and i cant open it!!

Thank you

Amin

[Ray.R]

Here it is in LV8.5

[James_W]

Thanks Ray, forgot to check which version we were working in.

James

[sam67]

---

@Ray.R wrote:

I didn't have LV2009 at this PC so I rewrote the same thing in LV8.5.

It appears to work well.  I'm not sure what you are seeing.

Here is the block diagram and I attach the VI.

Message Edited by Ray.R on 04-29-2010 09:38 AM

---

how we use this code for 2d array in which if string match then whole column just store in new array.