{"id":65073,"date":"2007-04-16T21:12:00","date_gmt":"2007-04-16T21:12:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2007\/04\/16\/how-can-i-read-the-contents-of-a-text-file-and-then-declare-the-contents-as-variables\/"},"modified":"2007-04-16T21:12:00","modified_gmt":"2007-04-16T21:12:00","slug":"how-can-i-read-the-contents-of-a-text-file-and-then-declare-the-contents-as-variables","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-read-the-contents-of-a-text-file-and-then-declare-the-contents-as-variables\/","title":{"rendered":"How Can I Read the Contents of a Text File and Then Declare the Contents as Variables?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I read the contents of a text file, and then declare those contents as variables?

— TC<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, TC. Before we begin, did you really<\/I> ask us this question? We\u2019re positive that you did, but, the way things have been going lately, we can\u2019t be too sure.<\/P>\n

For example, by now everyone has heard that Scripting Guy Jean Ross went down to San Diego for the MMS conference, only to return with nearly a dozen surgical staples in her head<\/B><\/A>.<\/P>\n\n<\/THEAD>\n\n\n
\n

Note<\/B>. If you haven\u2019t<\/I> heard, Jean was taking a leisurely stroll through the San Diego Zoo when she noticed that a group of kindergarteners, on a field trip, had accidentally wandered into the grizzly bears\u2019 compound. With complete and utter disregard for her own well-being Jean leaped over the fence, fought off the bears, and carried each and every child to safety. As it turned out, during the battle one of grizzlies took a swipe at Jean\u2019s head and managed to inflict a nasty gash. After the children were all safe and sound, Jean \u2013 true to form \u2013 went back into the compound, performed first aid on the grizzly\u2019s paw, and only then went to the hospital and had her own wound tended to.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n

<\/DIV>\n

But here\u2019s the weird part (interestingly enough, for Jean getting her head stapled together wasn\u2019t<\/I> the weird part). The other day our Scripting Hero called the insurance company with a question about her claim; the insurance company told her that they had no record of her being treated in San Diego. Apparently she hadn\u2019t<\/I> had her head stapled back together while in San Diego!<\/P>\n

It gets weirder. Last week<\/B><\/A> the Scripting Guy who writes this column was writing this column when his computer died. When he tried restarting it (and he tried many times) he always got the same message: Non-system or disk error. At one point he did manage to get into the BIOS, thinking he would run the hard disk diagnostic test. What happened? Nothing: that option was grayed-out. Apparently the computer didn\u2019t have<\/I> a hard disk.<\/P>\n

At that point the Scripting Guy who writes this column did what Scripting Guys always do in times of crisis: he went to lunch. When he came back he decided to try the computer one more time, just for the heck of it. Needless to say, it booted up just fine. He restarted it again, and again. No problem. He got back into the BIOS and discovered that his computer did have a hard disk; on top of that, it passed all the diagnostic checks with flying colors. Apparently his computer hadn\u2019t died after all.<\/P>\n

Very<\/I> weird.<\/P>\n

So, anyway, we can\u2019t be sure, TC, that you actually asked a question about reading lines from a text file and then declaring that information as variables. However, if you did<\/I> ask a question about reading lines from a text file and then declaring that information as variables here\u2019s the answer. <\/P>\n

Unless, of course, it turns out that we didn\u2019t answer your question after all. But let\u2019s try the following and see what happens:<\/P>

Const ForReading = 1<\/p>\n
Set objFSO = CreateObject(“Scripting.FileSystemObject”)\nSet objFile = objFSO.OpenTextFile(“C:\\Scripts\\Test.txt”, ForReading)<\/p>\n
Do Until objFile.AtEndOfStream\n    strLine = objFile.ReadLine\n    Execute strLine\nLoop<\/p>\n
objFile.Close<\/p>\n
Wscript.Echo strFirstName\nWscript.Echo strLastName\n<\/PRE>\n
OK. If we understand your question (that is, the question you either did or did not ask), you have a text file with lines similar to this:<\/P>
strFirstName = “Ken”\nstrLastName = “Myer”\n<\/PRE>\n
As you can see, each line looks an awful lot like a line of code assigning a value to a variable; in fact, if you typed these lines as-is into a script you\u2019d end up with a variable named strFirstName (with a value of Ken<\/I>) and a variable named strLastName (with a value of Myer<\/I>). Of course, you don\u2019t want<\/I> to type those lines as-is into a script; instead, you want to read those lines from a text file and then execute each line as if you had<\/I> typed it into the script. In other words, you want your script to function as though you had typed in those two lines of code, even though you never actually typed in those two lines of code.<\/P>\n
See? We told<\/I> you everything was getting weird!<\/P>\n
So how are we going to do all that (whatever it is)? Well, we\u2019re going to start off by defining a constant named ForReading and setting the value to 1; that\u2019s a constant we\u2019ll need when we open the text file. After the constant has been defined we next create an instance of the Scripting.FileSystemObject<\/B> object and then open the file C:\\Scripts\\Test.txt:<\/P>
Set objFSO = CreateObject(“Scripting.FileSystemObject”)\nSet objFile = objFSO.OpenTextFile(“C:\\Scripts\\Test.txt”, ForReading)\n<\/PRE>\n
Now for the good part. What we need to do next is read in the text file line-by-line, and then execute each line in the text file as though it was a line of code we had typed into our script. (Why do we keep using the verb \u201cexecute?\u201d You\u2019ll find out in just a second.) To do that, we first set up a Do Until loop designed to run until we reach the end of the text file (that is, until the file\u2019s AtEndOfStream<\/B> property is True). Inside that loop we use the ReadLine<\/B> method to read the first line from the text file and then store that value in a variable named strLine:<\/P>
strLine = objFile.Readline\n<\/PRE>\n
Got that? That simply means that strLine is equal to this:<\/P>
strFirstName = “Ken”\n<\/PRE>\n
Is that going to help us? You bet it is. To create a variable named strFirstName, with a value of Ken<\/I>, all we have to do now is call the Execute<\/B> statement followed by the value to be executed:<\/P>
Execute strLine\n<\/PRE>\n
The Execute statement is a little-known yet interesting feature of VBScript; among other things, this statement enables you to execute a string value (or variable) as if you had typed that value into your script as a line of code. Confusing? Yes. But take a look at this sample script:<\/P>
strMessage = “Hi”\nstrCode = “Msgbox strMessage”\nExecute strCode\n<\/PRE>\n
Here we\u2019ve stored the text value Hi<\/I> into a variable named strMessage. We\u2019ve then assigned the following value to a variable named strCode:<\/P>
Msgbox strMessage\n<\/PRE>\n
And you\u2019re right, that does<\/I> look like a line of code for displaying the value of strMessage in a message box. And there\u2019s a good reason for that: it is<\/I> a line of code for displaying the value of strMessage in a message box. That\u2019s the whole idea. In order to now run that line of code (that is, in order to display the message box) all we have to do is call the Execute statement followed by the string value (in this case, the variable strCode) we want to execute.<\/P>\n
Give it a try and you\u2019ll see what we\u2019re talking about.<\/P>\n
At any rate, when we call the Execute statement we end up executing this value:<\/P>
strFirstName = “Ken”\n<\/PRE>\n
And guess what? That\u2019s going to create a variable named strFirstName and assign it the value Ken<\/I>. And then we\u2019re going to loop around and repeat this process with the next line in the text file.<\/P>\n
Admittedly, this all sounds crazy. But look at what we get back when we echo back the values of strFirstName and strLastName:<\/P>
Ken\nMyer\n<\/PRE>\n
Obviously strFirstName and strLastName are valid variables. And how do you suppose they got assigned their respective values? You got it: from the information found in the text file. Pretty cool, huh?<\/P>\n
Admittedly, we\u2019re not sure how often you\u2019ll need to read lines of code from a text file and then declare those lines of code as variables. Nevertheless, there are times when the Execute statement is invaluable. What times? Well, for at least one example, see this event<\/B><\/A> from the 2007 Winter Scripting Games.<\/P>\n
Anyway, we hope that answers your question, TC. If it turns out that you didn\u2019t actually ask<\/I> us a question, well, that\u2019s OK: the ways things have been going lately we\u2019re not so sure we answered the question anyway. Have we mentioned the two Scripting Guys who signed up for TechEd 2007<\/B><\/A> and received emails confirming their registration, then a few days later received emails telling them that they hadn\u2019t <\/I>registered? Only then to be told that they did<\/I> register after all. Only \u2013 well, never mind. Most likely none of that happened, either. Either way, we\u2019ll see everyone at TechEd 2007.<\/P>\n
Assuming, of course, that there is<\/I> such a thing as TechEd 2007.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I read the contents of a text file, and then declare those contents as variables?— TC Hey, TC. Before we begin, did you really ask us this question? We\u2019re positive that you did, but, the way things have been going lately, we can\u2019t be too sure. For example, by now […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[3,4,14,5],"class_list":["post-65073","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-scripting-guy","tag-scripting-techniques","tag-text-files","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I read the contents of a text file, and then declare those contents as variables?— TC Hey, TC. Before we begin, did you really ask us this question? We\u2019re positive that you did, but, the way things have been going lately, we can\u2019t be too sure. For example, by now […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/65073","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=65073"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/65073\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=65073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=65073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=65073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}