BREAK DOWN SECTIONS IN A TEXT FILE USING VBSCRIPT

Samuel Fernandes

Total Post:159

Points:1117
Posted by  Samuel Fernandes
 1102  View(s)
Ratings:
Rate this:
Hi Expert, 

I have a file which is in this format

name.css  value
name.js  value 

I want to break this down and create strings which will be in this format string1 = "c:\" + value + name + extension(css or js) can someone please tell me how to do this in vbscript.

So far I am looking to break this into dictionary and then loop through and creating new dim objects which loops through the whole file and creates values but not getting it right.Any help is very much appreciated.

Any help would be amazing thank you!
  1. Vijay Shukla

    Post:100

    Points:700
    Re: Break down sections in a text file using vbscript

    Hi,

    Try this:

    Set fso = CreateObject("Scripting.FileSystemObject")

    Set re = New RegExp
    re.Pattern = "\s+"
    re.Global  = True

    Set f = fso.OpenTextFile("C:\your\input.txt")
    Do Until f.AtEndOfStream
      tokens = Split(Trim(re.Replace(f.ReadLine, " ")))
      WScript.Echo "C:\" & tokens(1) & tokens(0)
    Loop
    f.Close

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!