Extract info from txt file

[Erlend]

Hello

i have created a small application that collects varius information in a txt file, the txt file looks like this:

user input inn the application is username, and the information i need to get out is the data from SessionName and ServerName

so if i input User2 in my application i need to return data about SessionName and ServerName, i have looked at using FIND to return the line number and the use filereadlin to read this line + 1 and + 3 but i haven´t got it to work yet

the data that FIND returns if i use this is: [11]UserName : User2 so if i could get filereadline to read a line number based on that FIND returns the problem is solved.

expandcollapse popup

name            : 57a8:3:APP1
host            : SERVER1
zone            : 192.168.1.0
Version[Session] : 1
ProductType     : 12
SessionId       : 3
ClientName      : WI_HDYctb6leGHTXIFAL
UserName        : User1
SessionName     : ICA-tcp#107
LogonTime       : 0000-0124-fe040e07
ServerName      : SERVER1
AppName         : APP1
SessionConnectionType : 1
ClientNameIndex : WI_HDYctb6leGHTXIFAL
DomainUserNameIndex : DomainX\User1
HostId          : 22440
UserDomain      : DomainX
Protocols       : 1
DataType        : 1
ServerType      : 1
ClientType      : 1
LaunchedBrowserName : APP1
InitialBrowserName : APP1
SessionState    : 0
FullyQualifiedCredentials : DomainX\User1
SessionAuthenticationType : NT
00080022
       : 0
AccessSessionGuid : 
IsLastSessionApp : 1
DeviceId        : 
LogonString     : DomainX\User1
UPN             : \User1@DomainX.LOCAL
ADSDomain       : \User1@DomainX.LOCAL


name            : 2553:1:APP1
host            : SERVER2
zone            : 192.168.1.0
Version[Session] : 1
ProductType     : 12
SessionId       : 1
ClientName      : WI_ERnNBwRAfAsLlnd7O
UserName        : User2
SessionName     : ICA-tcp#36
LogonTime       : 0000-0124-fe03f58d
ServerName      : SERVER2
AppName         : APP1
SessionConnectionType : 1
ClientNameIndex : WI_ERnNBwRAfAsLlnd7O
DomainUserNameIndex : DomainX\User2
HostId          : 9555
UserDomain      : DomainX
Protocols       : 1
DataType        : 1
ServerType      : 1
ClientType      : 1
LaunchedBrowserName : APP1
InitialBrowserName : APP1
SessionState    : 0
FullyQualifiedCredentials : DomainX\User2
SessionAuthenticationType : NT
00080022
       : 0
AccessSessionGuid : 
IsLastSessionApp : 1
DeviceId        : 
00080027
       : DomainX\User2
LogonString     : DomainX\User2
UPN             : \User2@DomainX.LOCAL
ADSDomain       : \User2@DomainX.LOCAL

Thanks for any help

[Melba23]

Erlend,

This is one way of doing it.

#include <File.au3>

$sFilename = "Your_File_Path"

Global $aFileLines[1]

_FileReadToArray($sFilename, $aFileLines)

While 1

    $sUser = InputBox("User", "Input User name (blank to exit)")

    If $sUser = "" Then Exit

    For $i = 1 To $aFileLines[0]

        If StringinStr($aFileLines[$i], $sUser, 1) Then

            $aTemp = StringSplit($aFileLines[$i], ":")
            $sName = StringStripWS($aTemp[2], 3)
            $aTemp = StringSplit($aFileLines[$i + 1], ":")
            $sSessionName = StringStripWS($aTemp[2], 3)
            $aTemp = StringSplit($aFileLines[$i + 3], ":")
            $sServerName = StringStripWS($aTemp[2], 3)

            ConsoleWrite($sName & " - " & $sSessionName & " - " & $sServerName & @CRLF)

            ExitLoop

        EndIf
    Next

WEnd

This works on the test data you provided. If that is modified in any way you will, of course, need to modify this script accordingly. I have also not included any errorchecking which I strongly advise (incorrect Username entered, UserName not found, etc).

No doubt an SRE guru will be along in a minute with a wonderful pattern.

M23

[Erlend]

Thanks i will trie this, for now i have managed to resolve it by making a query by username, when the information is collected.