How to read CSV fields in from text file

[Guest_imported]

I want to read data elements in from a CSV text file and manipulate each field individually. Right now I only know how to read in the entire line.

How should I read in this text file, then separate each line into separate CSV fields? TIA! -James

TEXTFILE Example
192.168.1.1, HP 4000, Marketing
192.168.1.2, HP 8000, Administration

 

[JamesATL]

Got it...

'************************************************************
'* FUNCTION: READFILE(strFileName)
'*
'*
'*
'*
'************************************************************

Function ReadFile(strFileName)

Dim oFS, LineArray, Line, strData

Set oFS = CreateObject("Scripting.FileSystemObject&quot

If oFS.FileExists(strFileName) = True Then

Set File = oFS.OpenTextFile(strFileName)

While Not File.AtEndOfStream
Line=File.ReadLine
LineArray = Split (Line, ",&quot
WScript.Echo "Line: " & Line

For Each strData In LineArray
WScript.Echo strData
Next

WEnd

File.Close
Set oFS = Nothing

End If

End Function
'************************************************************

ReadFile "c:\test.txt"

***********
C:\TEST.TXT
172.28.19.101, HP 4000, Marketing
198.168.1.1, DeskJet 420, Administration