For loop over array in batch file

Question

I need some help. This code

for /f "usebackq delims=" %%a in (`
    mysql -u%dbUser% -e "SHOW DATABASES LIKE '%%sample%%';" 
    ^| findstr /l /v /c:"Database" /c:"information_schema"
`) do set a=%%a

has a result if echo %%a

 sample
 sample_test
 test_sample

but after the for loop with that code when i add echo %a% the result is only

 test_sample

how could it be so that i can still get the same output on echo %%a

So, from the previous question, that concatenates the databases names in the variable, if i understand you, what you need is to store a line feed between the names. Is this right? — MC ND
– MC ND, Commented Feb 12, 2015 at 7:31

Aacini · Accepted Answer · 2015-02-12 21:33:17Z

1

This do the trick:

@echo off
setlocal EnableDelayedExpansion

set LF=^
%empty line%
%empty line%

for /f "usebackq delims=" %%a in (`
    mysql -u%dbUser% -e "SHOW DATABASES LIKE '%%sample%%';" 
    ^| findstr /l /v /c:"Database" /c:"information_schema"
`) do set "a=!a!%%a!LF!"

echo !a!

answered Feb 12, 2015 at 21:33

Aacini

67.7k12 gold badges74 silver badges114 bronze badges

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

Comments

npocmaka · Accepted Answer · 2015-02-12 06:50:27Z

1

you need a delayed expansion

setlocal enableDelayedExpansion
for /f "usebackq delims=" %%a in (`
    mysql -u%dbUser% -e "SHOW DATABASES LIKE '%%sample%%';" 
    ^| findstr /l /v /c:"Database" /c:"information_schema"
`) do (
 set "a=!a! %%a"
 echo !a!
)
echo %a%

edited Feb 12, 2015 at 6:50

answered Feb 12, 2015 at 6:20

npocmaka

57.8k19 gold badges162 silver badges199 bronze badges

4 Comments

xXxrk04 Over a year ago

i already did that sir. what i want is when i add another code echo !a! outside the for loop . the output is only test_sample wherein i want to display sample sample_test test_sample same as !a! within the for loop.

npocmaka Over a year ago

@xXxrk04 - so you want to append the result to %a%?

xXxrk04 Over a year ago

the result of !a! is sample sample_test test_sample and the result of %a% is only test_sample .. i want %a% has the same output with !a!

npocmaka Over a year ago

@xXxrk04 - not sure what you mean.The last echo %a% should contain all lines....?

Collectives™ on Stack Overflow

For loop over array in batch file

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related