reading variables value from text file in batch script

Question

In my BAT file, i want to read these data from .txt file and need to set each data into one variable

    SQLUserName=MFiles
    WrapperSQLServerName=usa.com
    WrapperDatabase=Wrapper
    WrapperAssemblyLocation=D:\Assembly
    MFilesNetworkAddress=USA-S1
    MFilesVaultName=MF2
    MFilesUsername=User
    MFilesPassword=
    MFilesVaultGUID={26F30-E120-408C-8035-04D85D6}
    MFilesWebServerURL=www.WebServer.com
    SQLMailProfileName=NoReply
    [email protected]

I tried with this code

FOR /F "tokens=2 delims==" %%a IN ('find "WrapperSupportEmail" ^<config.txt') DO SET SupportEmail=%%a

But it throws error

find is not recognized as an internal or external command operable program or batch file

Please help me

Thejus T V

Try running find in an interactive command prompt.

woxxom
– woxxom

2015-07-27 10:40:10 +00:00
Commented Jul 27, 2015 at 10:40 — woxxom
– woxxom, Commented Jul 27, 2015 at 10:40

Dlanod Kcud · Accepted Answer · 2015-07-27 10:43:35Z

3

If the schema of your input file is fixed (keyword=value) and you want to assign all values to an environment variabel named keyword it is very, very easy. try this:

for /f "tokens=1,2 delims==" %i in (config.txt) do set %i=%j

remember to change %i and %j to %%i and %%j if you want to put this call into a cmd-file.

edited Jul 27, 2015 at 10:43

answered Jul 27, 2015 at 10:41

Dlanod Kcud

5376 silver badges15 bronze badges

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

5 Comments

Stephan Over a year ago

as the file is fine formatted: for /f "delims=" %i in (config.txt) do set %i

thejustv Over a year ago

Text file always in the same for formatted as show above.So how we can set each key value into one variable?

Aacini Over a year ago

As indicated in @Stephan's comment above yours. It is equivalent to execute: set SQLUserName=MFiles, then set WrapperSQLServerName=usa.com, etc...

thejustv Over a year ago

@Aacini I want to read the data from .txt file and set to a variable from Batch file

Aacini Over a year ago

@thejustv: Please, modify your original question and insert an additional description that clearly state what you want as result!

Stephan · Accepted Answer · 2015-07-28 15:51:50Z

0

when two members with high reputation tell you it works, then it shouldn't be the worst of all ideas to at least try it.

rem @echo off
for /f "delims=" %%i in (config.txt) do set _%%i
pause
set _

I REMd the @echo off, so you can watch, how every single line get's processed.

(Your original error find is not recognized ... is probably because you messed up your %path%-variable, but you don't need find for this task.)

answered Jul 28, 2015 at 15:51

Stephan

56.7k11 gold badges66 silver badges97 bronze badges

Comments

thejustv · Accepted Answer · 2015-07-30 13:52:49Z

0

My code is correct one only. Only issue is windows cant locate find.exe. I included the .exe on same location and after that everything works fine.

Its working fine in Win 7 and Win 10 without adding Find.exe

answered Jul 30, 2015 at 13:52

thejustv

2,02527 silver badges43 bronze badges

Collectives™ on Stack Overflow

reading variables value from text file in batch script

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related