Reading a CSV file using VBScript

Question

I have a file with 4 fields.

A,B,C,D

I want to only extract the 4th Field and change it to "E"

Is there anyway to accomplish this?

Are the fields fixed length or variable length?

Daniel Wolfe
– Daniel Wolfe

2011-08-17 13:26:26 +00:00
Commented Aug 17, 2011 at 13:26 — Daniel Wolfe
– Daniel Wolfe, Commented Aug 17, 2011 at 13:26

Hans Olsson · Accepted Answer · 2011-08-17 13:34:51Z

10

Assuming that the values don't contain commas, read in the file using FileSystemObject (FSO), then Split each line on commas. Change the resulting array of 4 values as needed, then join it together as a comma separated string again. When you've done all the changes, write the data back out to a file using FSO.

So something like:

Set outputFile = fso.OpenTextFile(FileName1, ForWriting, True)
Set inputFile = fso.OpenTextFile(FileName2, ForReading)
Do While inputFile.AtEndOfStream <> True
    arr = Split(inputFile.ReadLine, ",")
    arr(3) = "E"
    outputString = Join(arr, ",")
    outputFile.WriteLine outputString
Loop

Please note, the code is completely untested and written mostly from memory so is almost certainly not correct but just to give you an idea.

edited Aug 17, 2011 at 13:34

answered Aug 17, 2011 at 13:29

Hans Olsson

55.1k16 gold badges99 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

HDSSNET · Accepted Answer · 2017-08-16 21:42:34Z

-3

Maybe a simple Replace would work.

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("c:\data.txt")
strSearchString = objFile.ReadAll
objFile.Close

strSearchString = Replace(strSearchString,"A,B,C,D","A,B,C,E")

Set objFile = objFSO.OpenTextFile("c:\data.txt",2)
objFile.Write strSearchString
objFile.Close

answered Aug 16, 2017 at 21:42

HDSSNET

1273 bronze badges

1 Comment

Stephan Over a year ago

The values A, B, C, ... were just samples. Furthermore the old answer should do the job fine.

Collectives™ on Stack Overflow

Reading a CSV file using VBScript

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related