Tuesday, February 8, 2011

Reading text files on MS-DOS

In my previous entry, I was trying to process a text files (a CSV), using each line of that file as input for my SQL*Plus call.
But, what happens if you don't have a UNIX box where you can execute it??? :(
Let's write my shell script into a batch file (oh man!), and this is the result: Where %%a is the first token, %%b the second one, and so on (until we'd reached the fourth token - as specified on tokens=1,2,3,4)
At the end, it was simple :D

No comments:

Post a Comment