• Announcements

    • xper

      MSFN Sponsorship and AdBlockers!   07/10/2016

      Dear members, MSFN is made available via subscriptions, donations and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, become a site sponsor and ads will be disabled automatically and by subscribing you get other sponsor benefits.
Ruriko

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

2 posts in this topic

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
Next

'Cleanup
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
0

Share this post


Link to post
Share on other sites

Try this vbs script that will read contents of text file and write them to a new text file.

Demo_Recursive_List_Text.vbs

'-> 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, TxtTxt = Act.SpecialFolders("Desktop") & "\List_Text_Contents.txt"'-> Makes The Folder Where Script Resides Parent Folder For RecursiveList(Fso.GetFolder("."))'-> Add Path Fso.GetFolder("SomeDrive\FolderName")Function List(Folder)'-> List Files In FolderFor Each Col In Folder.FilesIf LCase(Right(Col,3)) = "txt" ThenSet Ts = Fso.OpenTextFile(Col)Arg = Ts.ReadAllTs.CloseIf Fso.FileExists(Txt) ThenSet Ts = Fso.OpenTextFile(Txt,8)Ts.WriteLine Col.Name & vbCrLfTs.WriteLine ArgTs.CloseElseSet Ts = Fso.CreateTextFile(Txt)Ts.WriteLine Col.Name & vbCrLfTs.WriteLine ArgTs.CloseEnd IfEnd IfArg = ""Next'-> Loop Threw All Sub FoldersFor Each Obj In Folder.SubFoldersList(Obj)NextEnd Function
0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.