vbscript how to open a file and read/write to it

hi there

i want to know how to open and read/write to a file in vbscript. i search and purchased tutorials but they havent shown me. can someone help

thank you for your support
LVL 2
AntonInfAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wayne Taylor (webtubbs)Commented:
What sort of file? If it's a simple text file, use File System Object.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JesterTooCommented:
Here is a sample script that copies a text file.  It will either overwrite the original file or create a new one depending on how many filenames are specified on the command line when you run it.

Save this script in a file named filecopy.vbs (or whatever you want) and run it like this:    vbscript filecopy.vbs file1 file2

If you only give it one file name it will overwrite that file (since the script does not make any changes to the content it doesn't really serve any purpose other than to demonstrate the file opening, reading, writing, and closing features of the File System Object.



' Define needed constants
Const ForReading = 1
Const ForWriting = 2
Const TriStateUseDefault = -2

' Get input file name from command line parm, if 2 parms entered
' use second as new output file, else rewrite to input file
If (WScript.Arguments.Count > 0) Then
    sInfile = WScript.Arguments(0)
Else
    WScript.Echo "No filename specified."
    WScript.Quit
End If
If (WScript.Arguments.Count > 1) Then
    sOutfile = WScript.Arguments(1)
Else
    sOutfile = sInfile
End If

' Create file system object
Set oFSO = CreateObject("Scripting.FileSystemObject")

' Read entire input file into a variable and close it
Set oInfile = oFSO.OpenTextFile(sInfile, ForReading, False, TriStateUseDefault)
sData = oInfile.ReadAll
oInfile.Close

' Write the file
Set oOutfile = oFSO.OpenTextFile(sOutfile, ForWriting, True)
oOutfile.Write(sData)
oOutfile.Close

Open in new window

0
Bill PrewCommented:
The code that JesterToo posted above is how I usually do it, using the FileSystem object.  In between the lines of code that read the file, and the lines that write the file you would typically have logic that processed the array of lines from the input file, building the output you want.  For an example take a look at my accepted solution in the following older question on this site:


For additional learning and info on the FileSystem object usage take a look at these pages that explain in more detail.


~bp
0
AntonInfAuthor Commented:
thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.