automatic file generation

[jamie310382]

What I want to do is write data to a spreadsheet file and have this file named from a user input string earlier in the code ( I am passing all the user inputs through each VI via clusters). For example, one of the user inputs is "Unique Valve ID Number". Therefore when I write my data to a spreadsheet, I automatically want the file name to be the Unique valve ID number without a dialogue box appearing asking me to type this in. I also want the file to be save automatically to a specific location on my network every time.

As a result each time I log a test, the filename will be the unique valve ID number and all the files will be located in the same location.

Can anyone help. (I am using labview 7.1 if anyone is sending in an example good)

Thank you.

Jamie

[smercurio_fc]

You just need to create your path as a string and then use the String to Path function. As an example:

Message Edited by smercurio_fc on 07-12-2007 09:06 AM

[jamie310382]

Thanks,

Seems like this would work if it were just a number I was using, but the unique valve ID number is in the following format "VLV-163480-01".

Jamie

[smercurio_fc]

I was just providing that as an example. Clearly you would need to modify the format string to suit your purposes. In your case you can just change the %d to %s and feed in your valve number as a string. You could also use the Concatenate Strings function. Both methods get you to the same place: a string that correponds to a path. Please take a look at the documentation for the Format Into String function.

[jamie310382]

Thanks alot. Fairly new to this so your help is much appreciated. Works fine.

[smercurio_fc]

No problem.

I have no idea who gave you a one-star rating on your reply, but it was not deserved. We seem to have another case of intolerance on this board. Either that or another troll.

[Joe_H]

I gave you a 5 star just to help the ratings. I say 5 stars or no stars at all. You now have a rating of 3

[jamie310382]

thanks guys