Batch Script-Query regarding for loop

Question

This is my batch script to read csv file and assigning values to batch variables. This script reads the file perfectly, but when it comes to the last line of csv file...the last line is executed twice. I am not getting the reason why the last line is read twice. Following is my batch code

@echo off

:: Set input file in _variable
Set _InputFile=%1

:: Store input line into different _variables
FOR /F "tokens=1-4* delims=," %%A IN (%_InputFile%) DO (
    Set _var1=%%A
    Set _var2=%%B
    Set _var3=%%C
    Set _var4=%%D
CALL :PROCESS
)

:PROCESS
IF "%_var1%"=="Application Name" echo FIRST LINE
IF "%_var1%"=="Transition Portal" echo %_var2%
IF "%_var1%"=="Coast" echo %_var2%
IF "%_var1%"=="TI" echo %_var2%

This is my csv file:

Application Name,Environment,Release No.,Revision No.

Transition Portal,Test,,

Coast,Dev,handle,0

TI,Prod,check,3

The output I get is:

FIRST LINE

Test

Dev

Prod

Prod

If you notice 'Prod' got printed two times. Can anyone please let me know why is the last line executed two times?

RGuggisberg · Accepted Answer · 2014-06-03 10:37:27Z

1

You need to add the line goto :eof because you are falling through to the subroutine when done with the FOR loop.

CALL :PROCESS
)
GOTO :eof

You should also add GOTO :eof as the last line of :PROCESS. Yes, it works now, but if someone adds to your code later things will not work as expected.

answered Jun 3, 2014 at 10:37

RGuggisberg

4,7802 gold badges21 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Batch Script-Query regarding for loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related