{"id":67163,"date":"2006-06-07T12:46:00","date_gmt":"2006-06-07T12:46:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2006\/06\/07\/how-can-i-add-leading-zeroes-to-all-the-lines-in-a-text-file\/"},"modified":"2006-06-07T12:46:00","modified_gmt":"2006-06-07T12:46:00","slug":"how-can-i-add-leading-zeroes-to-all-the-lines-in-a-text-file","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-add-leading-zeroes-to-all-the-lines-in-a-text-file\/","title":{"rendered":"How Can I Add Leading Zeroes to All the Lines in a Text File?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! I have a text file where each line is a set of characters like this: 56A63, 78A41, etc. I need to put leading zeroes in front of these strings in order to make them all nine characters long: 000056A63, 000078A41, etc. Oh: and my text file has 20,000 lines that need to be modified like this. How can I do all that using a script?

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

Hey, JC. You know, at first we were going to ask another one of the Scripting Guys to answer this question. For one thing, this Scripting Guy happens to be a world-class expert on scripting, and does a far better job of explaining complicated scripting techniques than the rest of us could even dream<\/I> of doing. More important, she\u2019s playing in a Microsoft-sponsored softball league, and from what she\u2019s told us her batting average is filled<\/I> with zeroes; she should have more than enough to share with you. (Editor\u2019s Note: Keep in mind these biting comments came from the Scripting Guy who insists he\u2019s too good to play with the rest of us. Funny how none of us has ever actually seen him play though.)<\/I><\/P>\n

But then we thought, \u201cGosh, that would hardly be like Hey, Scripting Guy!<\/I> to make fun of a co-worker.\u201d And so we decided to throw together this script instead:<\/P>

Const ForReading = 1\nConst ForWriting = 2<\/p>\n
Set objFSO = CreateObject(“Scripting.FileSystemObject”)\nSet objFile = objFSO.OpenTextFile(“C:\\Scripts\\Test.txt”, ForReading)<\/p>\n
Do Until objFile.AtEndOfStream\n    strText = objFile.ReadLine\n    intLength = Len(strText)\n    intZeroes = 9 – intLength\n    For i = 1 to intZeroes\n        strText = “0” & strText\n    Next\n    strContents = strContents & strText & vbCrlf\nLoop<\/p>\n
objFile.Close<\/p>\n
Set objFile = objFSO.OpenTextFile(“C:\\Scripts\\Test.txt”, ForWriting)\nobjFile.WriteLine strContents<\/p>\n
objFile.Close\n<\/PRE>\n
Incidentally, we actually tested this on a text file with 20,000 lines in it. Not only did it work, but it worked pretty dang fast: in less than 30 seconds we were done. Which is just about the length of time it takes our fellow Scripting Guy to walk to the plate and then head back to the dugout, another at-bat over and done with.<\/P>\n
Not that we would mention anything like that, mind you.<\/P>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. At first we were concerned that our co-worker might work on her swing by taking a few cuts at us<\/I>. But considering the way she hits a softball, well, we were willing to take that chance.<\/P>\n
And, yes, now that you mention it we are<\/I> starting to get a little concerned for our safety.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
But what about the script? Well, we start out by defining a pair of constants, ForReading and ForWriting; we\u2019ll use these constants to indicate how we want to open the text file in question. As you know, we can\u2019t simultaneously read to and<\/I> write from a text file; instead, we have to open the text file, read in the contents, modify those contents (by adding the leading zeroes), close the file, re-open the file, and then<\/I> replace the existing lines with the modified lines. It\u2019s a tad bit cumbersome, but we don\u2019t have a lot of choice in the matter.<\/P>\n
After defining out constants we create an instance of the Scripting.FileSystemObject<\/B>, the scripting object used for working with text files. We then call the OpenTextFile<\/B> method, passing two parameters: the path to the file we want to open (C:\\Scripts\\Test.txt) and the constant ForReading. (Why ForReading? Because, as we noted a moment ago, the first step in this process is to read in the contents of the file.)<\/P>\n
With the file open we\u2019re ready to roll up our sleeves and get to work. What we\u2019re going to do next is read the file line-by-line, adding the leading zeroes as we go. To do that we set up a Do Until loop that runs from the beginning of the file to the end of the file. (How do we know that we\u2019ve reached the end of the file? We\u2019ve reached the end when the AtEndOfStream<\/B> property is True.) Inside that loop we use this line of code to read the first line of the file and store the contents in a variable named strText:<\/P>
strText = objFile.ReadLine\n<\/PRE>\n
After we read in the line we\u2019re ready to add the leading zeroes. However, there\u2019s one complication here: as JC noted in her email, the number of characters in each line varies. That is, we might have 123<\/I> on one line, then have 12345<\/I> on another line. That means we can\u2019t simply add the same number of leading zeroes to each line and call it good. (Remember, the goal is to end up with a string nine characters long.)<\/P>\n
But that\u2019s a minor complication. To begin with, we use the Len<\/B> function to determine the number of characters in strText. For example, suppose the first line in the text file is 1234<\/I>; in that case, Len will return a 4, because strText contains 4 characters. That\u2019s what this line of code does:<\/P>
intLength = Len(strText)\n<\/PRE>\n
Next we subtract the variable intLength (the length of the string) from 9. Why? Well, that tells us how many leading zeroes we need to add. With a 4-character string we subtract 4 from 9, leaving 5. That means we need to add 5 leading zeroes. Here\u2019s the line of code that carries out that calculation, with the required number of zeroes getting stored in a variable named intZeroes:<\/P>
intZeroes = 9 – intLength\n<\/PRE>\n
As far as adding the leading zeroes, we decided the easiest way to do that was to use a For Next loop that runs from 1 to the number of zeroes we need to add:<\/P>
For i = 1 to intZeroes\n    strText = “0” & strText\nNext\n<\/PRE>\n
As you can see, each time through the loop we assign a new value to the variable strText: that new value is simply a 0 (as a character, not as a number) followed by the existing value of strText. The first time through the loop we\u2019ll have 0 followed by 1234, making strText equal to 01234. The second time through the loop we\u2019ll have 0 followed by 01234, yielding 001234. This continues until we have 9 characters in the string.<\/P>\n
The net effect: we\u2019ve now taken the first line of the text file and added the necessary leading zeroes. Ideally, at this point we\u2019d simply write the revised line back to the file. As we pointed out earlier, though, the FileSystemObject doesn\u2019t let us read and write to a file at the same time. Therefore we need to temporarily store all the revised lines in memory, something we do here:<\/P>
strContents = strContents & strText & vbCrlf\n<\/PRE>\n
All we\u2019re doing here is basically building our revised text file in memory. After the new file has been constructed we can then go ahead and write it to the actual file C:\\Scripts\\Test.txt.<\/P>\n
Next we loop around and repeat the process with the second line in the text file, eventually adding the modified second line (plus a carriage-return linefeed, represented by the VBScript constant VbCrLf<\/B>) to the variable strContents. That means that, after we\u2019ve read through the entire file, strContents will contain 20,000 modified lines of text.<\/P>\n
All we need to do at that point is replace the existing contents of the text file with the 20,000 modified lines stored in strContents. To do that we close the file, then immediately re-open it, this time for writing:<\/P>
Set objFile = objFSO.OpenTextFile(“C:\\Scripts\\Test.txt”, ForWriting)\n<\/PRE>\n
We then call the WriteLine<\/B> method to write the revised contents to the text file (overwriting the existing contents), a process that looks like this:<\/P>
objFile.WriteLine strContents\n<\/PRE>\n
And that\u2019s it. We close the text file, and we\u2019re free to move on to something else. Something like, say, batting practice.<\/P>\n
Well, for those of us who need it, that is \u2026.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! I have a text file where each line is a set of characters like this: 56A63, 78A41, etc. I need to put leading zeroes in front of these strings in order to make them all nine characters long: 000056A63, 000078A41, etc. Oh: and my text file has 20,000 lines that need to […]<\/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-67163","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! I have a text file where each line is a set of characters like this: 56A63, 78A41, etc. I need to put leading zeroes in front of these strings in order to make them all nine characters long: 000056A63, 000078A41, etc. Oh: and my text file has 20,000 lines that need to […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/67163","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=67163"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/67163\/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=67163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=67163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=67163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}