vbs script to read a mixed variable file

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