Find a expression after a specific text

[dion]

Hi Folks,

I had been searching online for some help but failed. I would like to my script to find the word after a specific word, but my script it does not return the field after it.

My scripts look something like this:

$FileName = @ScriptDir & "\TEST.txt"

$Backup = @ScriptDir & "\TEST-BCK.txt"

FileCopy ($FileName, $Backup)

$FileContents = FileRead($FileName)

$Results = StringSplit( "Password", ":",2)

Msgbox(0,"Status","Password: " & $Results)

What I wish to achieve is that it would search for this string call password in this particular file and then it would return the filed after it.

The text file looks something like this:

==================================================

Name : Test123

Application : MS Outlook 2002/2003/2007

Email : test123@isp.com.sg

Server : pop.isp.com.sg

Type : POP3

User : user123

Password @ssw0rd

Profile : Outlook

==================================================

Any help would be appreciated, thank you in advance.

Edited July 16, 2010 by dion

[rosaz]

You could try searching between the ":" and the character after the password- maybe something like this?:

$FileName = @ScriptDir & "\TEST.txt"
$Backup = @ScriptDir & "\TEST-BCK.txt"

FileCopy ($FileName, $Backup)
$FileContents = FileRead($FileName)

$passwordloc = StringinStr($FileContents, "Password"); finds the number of the first character of password
$passwordfinloc = $passwordloc + 9 ;find the first character after "Password:"
$profileloc = StringinStr($FileContents, "Profile")
$userpassword = StringMid($FileContents, $passwordfinloc, $profileloc - $passwordfinloc) ;finds the characters between the two

[Ascend4nt]

$sBuffer="Name : Test123"&@CRLF& _
"Application : MS Outlook 2002/2003/2007"&@CRLF& _
"Email : test123@isp.com.sg"&@CRLF& _
"Server : pop.isp.com.sg"&@CRLF& _
"Type : POP3"&@CRLF& _
"User : user123"&@CRLF& _
"Password :P@ssw0rd"&@CRLF& _
"Profile : Outlook"
$aMatch=StringRegExp($sBuffer,"Password\s*\:\s*(.*)",1)
If Not @error Then ConsoleWrite("Match:"&$aMatch[0]&@CRLF)

*edit: code tags

Edited July 16, 2010 by Ascend4nt

[dion]

Thanks folks, I would give it a try on this.

[dion]

Thanks folks, I had tried and it works. Thank you so much.

Ascend4nt>> I did not use your as I do not understand it, my apologies as I'm very new with scripting. Could I ask what is the usage \s* ?

[GEOSoft]

Thanks folks, I had tried and it works. Thank you so much.

Ascend4nt>> I did not use your as I do not understand it, my apologies as I'm very new with scripting. Could I ask what is the usage \s* ?

In a regular expression it means match any spaces that may or may not appear before and after the colon. It would match any of the follwing plus any where multiple spaces were used in the same positions

• Password:mypassword
• Password: mypassword
• Password : mypassword
• Password :mypassword

[dion]

thk you for the info.