vbs script to read a mixed variable file

[Katto]

Hello,

I need to read a list of 3 columns where column A & C are strings and column B consists of numbers
They are comma separated as shown below

A,2,C
V,3,G
U,1,R
etc

I tried:
==========================
while eof(1)=false
line input#1,T$
TT=split(T$,",")
==========================
and
==========================
while eof(1)=false
input#1, S1,N1,S2
=========================

non of these gave me the results I was looking for. Looks like the lines ignore the newline

Any ideas?

Thanks

 

[mikrom]

Hi Katto,
Reading the file like you tried works in VBA (for example in Excel), but not in VBscript.
To read the file in Vbscript use the Scripting.FileSystemObject.
If you need a working example, you can look here:

https://www.tek-tips.com/viewthread.cfm?qid=1649483

 

[Katto]

Thank you. That worked