Trying to read a text file content and set variables values from that

batch file

I have a batch file that creates a text file with its output like the following:

RESULT=0&SECURETOKEN=SmH3kciXiVkiwD0i70CwKYgAR&SECURETOKENID=2013031414280240&RESPMSG=Approved

The length of the variables is constant, so it is easy to parse the value from the string. Delimits for all name-value pairs are ampersands.

Then, from within the first batch file, I need to call another batch file and use two variable values from the text file content:

SECURETOKEN

and

SECURETOKENID

Using the following part in the second batch does not help, where Temp_result.txt is the file that contains the output.

set /p out=<{full path to the file}\Temp_result.txt
set SECURETOKEN=%out~21,25%
set SECURETOKENID=%out~61,16%

Can anybody help me out, please?

Best Answer

You are missing the : after your variable name. So your commands would be:

set /p out=<{full path to the file}\Temp_result.txt
set SECURETOKEN=%out:~21,25%
set SECURETOKENID=%out:~61,16%

Related Solutions

Using Call SET to Designate a Variable in a Dos Batch “For” Loop

You have 2 problems:

1) You are confusing FOR variables with environment variables. A batch FOR variable name is always a single character, and it is access via 2 percents prior to the name: %%c. A FOR variable value cannot be changed with SET.

An environment variable name can contain multiple characters, though it can be a single character, and it is accessed by enclosing the name in percents: %var%. Exclamation points can be used if you want delayed expansion: !var!. An environment variable value is set with SET.

2) The CALL trick to access environment variable values that were set within a parenthesized code block is used at expansion time, not when you are setting the value.

I believe mousio provided provided the best answer; I always use delayed expansion like in that answer. But it is possible to do what you want without delayed expansion by properly using an environment variable and the CALL trick.

@echo off
for /f "tokens=1-3 delims=," %%a in (Puck.csv) do (
  echo Hello No Hockey>%%a.txt
  echo #:A %%a>>%%a.txt
  echo #:B %%b>>%%a.txt
  set C=%%c
  if /i %%c gtr 10 set C=1
  call echo #:C %%C%%>>%%a.txt
)

Note that it is critical that the case of the FOR variable is different than the environment variable. FOR variables are case sensitive, environment variables are not. If you use c for both, then the parser will treat %%c%% as the FOR variable followed by a percent - not what you want.

BATCH script to find string from file and append like variable in file name

Something is wrong in my code

findstr /I "LastLogedUser=" something.txt is returning the whole line from the file:

> findstr /I "LastLogedUser=" something.txt
LastLogedUser=John.Doe

So your for loop needs to use = as a delimiter and get the second token in order to extract John.Doe.

I've also added some "s in case there are spaces in the user name ...

Corrected batch file:

@echo off
setlocal
for /F "tokens=2 delims==" %%a in ('findstr /I "LastLogedUser=" something.txt') do set "uniuser=%%a"  
echo User is: %uniuser%   
copy fpr_log.txt "c:\fpr_log%uniuser%.txt"
endlocal

Best Answer

Related Solutions

Using Call SET to Designate a Variable in a Dos Batch “For” Loop

BATCH script to find string from file and append like variable in file name

Something is wrong in my code

Further Reading

Related Question