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
Our community of experts have been thoroughly vetted for their expertise and industry experience.