serach value

[elyan]

Hi all :

Please see attach file , this vi create folder and save data  what I want to do , when i insert S/N number , search for this number in the file , if  Number Exist then stop if not Counties  saving data  ,

 Right now if the number exist or not exist always data saved

How can I do that

[MikeS81]

Hello elyan

can you attach your "insert S/N.vi"?

You can solve your problem by connecting an output of your "New device.vi" to the while loop condition and if the serial number exists you set the cancel button value to true.

Mike 

[elyan]

may be i didn't explain my self crearly :

i want to serach the value in xls file , if this value exist then stop , if the value in EXCEL file does not exist then write to the file

as you see my vi , saved data to excel , but if i insert  the same value it will save it anyway

thanks

[MikeS81]

Excuse me,

but i see no vi which search for an existing S/N.

Mike

[elyan]

that's my problem :

i don't know how to do that

[MikeS81]

OK. Now i understand the problem.

I make an example for you. It´s not the best way but it works.

Mike

[elyan]

thanks alot