CSV export from databse parsing and manipulation

I have a CSV file that I am creating with SQLPlus from an oracle databse.  The layout of the file is as follows:

"number","idType","state","country","IDnumber"

What I need to do is create a VB script or batch file to read the file and do the following:

if (idType == "1") { output to a new file "number","DL""state""IDnumber" }
if (idType == "2") { output to a new file "number","PA""country""IDnumber" }

So if my orignal file looked liek this:

123456789,1,TX,,12345
987654321,2,,US,54321

The new file would look like this:

123456789,DLTX12345
987654321,PAUS54321

Any help would be greatly appreciated