extract portion of text from cmd

Question

I need to extract a portion of text from a text file log.txt, where the contents of the file are as follows.

 SESSIONNAME       USERNAME                 ID  STATE   TYPE        DEVICE 
services                                    0  Disc                        
console                                     1  Conn                        
                   input1                   3  Disc                        
 rdp-tcp#0         input2                   4  Active  rdpwd               
                   input3                   6  Disc                        
 rdp-tcp                                 65536  Listen                      

Specifically, I need the SESSION ID of a specific username. Need help in extracting the same. Any advice or help will be much appreciated.

Thanks.

Answer 1

Next script shows possible approach using extract part of a variable (substring).

@ECHO OFF >NUL
SETLOCAL EnableExtensions EnableDelayedExpansion
for /F "usebackq delims=" %%G in ("D:\test\QuerySessionLog.txt") do (
  set "logline=%%~G"
  set "_SESSIONNAME=!logline:~0,18!"
  set "_USERNAME=!logline:~18,18!"
  set "_ID=!logline:~36,11!"
  set "_STATE=!logline:~47,8!"
  set "_TYPE=!logline:~55,7!"
  set "_DEVICE=!logline:~62!"

  echo !logline!
  for /F "tokens=1,* delims==" %%g in ('set _') do (
    set "trimentry=%%h"
    if "!trimentry:~0,1!"==">" (
      call :TRIM !trimentry:~1!
    ) else (
      call :TRIM !trimentry!
    )
    echo %%g=[!trimresult!] ^(raw=[%%h]^) 
  )
  echo( 
) 
:endlocal
ENDLOCAL
goto :eof

:TRIM
  SET "trimresult=%*"
GOTO :EOF

Please note that I'm absolutely not sure about rightness of column widths as another example provided in query session command reference shows another format.
However, column widths could be computable from the header line (but this would exceed current question topic).

Answer 2

That looks like fixed-width data, so let's use GNU awk: user "input2" has id "4"

$ gawk -v FIELDWIDTHS="19 25 3 99" -v user=input2 '$2 ~ "^"user {print $3}' log.txt
4