Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


[Solved] Go to path and read txt file in vbscript

- - - - -

  • Please log in to reply
1 reply to this topic


  • Member
  • 6 posts
  • Joined 27-October 12
  • OS:Windows 7 x86
  • Country: Country Flag
I have a list full of directories and I want to loop through those directories and open the txt file. Then read the data inside that txt file and assign to a variable.

This is an example of the directory list looks like:
C:\Documents and Settings\Administrator\Desktop\ArtistCG\[ Go! Go! Heaven!!]_____________25 -______ ___- [525067]\test.txt
C:\Documents and Settings\Administrator\Desktop\ArtistCG\[12CUT] _____ (Gakkou no Kaidan) [518382]\test.txt
C:\Documents and Settings\Administrator\Desktop\ArtistCG\[2____] _____!__CD__________ [521206]\test.txt
C:\Documents and Settings\Administrator\Desktop\ArtistCG\[Ability] _____________________ [514182]\test.txt
C:\Documents and Settings\Administrator\Desktop\ArtistCG\[Abo Manten] Kyuusho seme maniacs vol. 3 (Weak Spot Maniacs vol.3) [521993]\test.txt
C:\Documents and Settings\Administrator\Desktop\ArtistCG\[Afro] Futanari angel cg collection [521560]\test.txt
C:\Documents and Settings\Administrator\Desktop\ArtistCG\[Aim-ZERO] Case Vol.4 [519927]\test.txt
C:\Documents and Settings\Administrator\Desktop\ArtistCG\[Air Hike] ________CG_2 [525114]\test.txt

Now here's the code
Option Explicit

Dim objFSO, strTextFile, strData, strLine, arrLines
CONST ForReading = 1

'name of the text file
strTextFile = "C:\Documents and Settings\Administrator\Desktop\ArtistCG\folders.txt"

'Create a File System Object
Set objFSO = CreateObject("Scripting.FileSystemObject")

'Open the text file - strData now contains the whole file
strData = objFSO.OpenTextFile(strTextFile,ForReading).ReadAll

'Split the text file into lines
arrLines = Split(strData,vbCrLf)

'Step through the lines
For Each strLine in arrLines
wscript.echo strLine

Set objFSO = Nothing

Now the problem with the code is it reads the contents of folders.txt instead of going to the directory and read the test.txt file. Can anyone help me fix this?

Edited by Ruriko, 30 October 2012 - 06:48 PM.

How to remove advertisement from MSFN



    MSFN Master

  • Super Moderator
  • 2,243 posts
  • Joined 02-August 03
  • OS:none specified
  • Country: Country Flag
Try this vbs script that will read contents of text file and write them to a new text file.

'-> This code is property of Gunsmokingman and Or Jake1Eye and you must have his permission to use.
'-> This is only posted as example code and meant only to used as such.
Dim Act :Set Act = CreateObject("Wscript.Shell")
Dim Fso :Set Fso = CreateObject("Scripting.FileSystemObject")
Dim Arg, Col, Obj, Ts, Txt
Txt = Act.SpecialFolders("Desktop") & "\List_Text_Contents.txt"
'-> Makes The Folder Where Script Resides Parent Folder For Recursive
'-> Add Path Fso.GetFolder("SomeDrive\FolderName")
Function List(Folder)
'-> List Files In Folder
For Each Col In Folder.Files
If LCase(Right(Col,3)) = "txt" Then
Set Ts = Fso.OpenTextFile(Col)
Arg = Ts.ReadAll
If Fso.FileExists(Txt) Then
Set Ts = Fso.OpenTextFile(Txt,8)
Ts.WriteLine Col.Name & vbCrLf
Ts.WriteLine Arg
Set Ts = Fso.CreateTextFile(Txt)
Ts.WriteLine Col.Name & vbCrLf
Ts.WriteLine Arg
End If
End If
Arg = ""
'-> Loop Threw All Sub Folders
For Each Obj In Folder.SubFolders
End Function


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users