Sign in to follow this  
Followers 0
aawaara

Find/Read a number??

4 posts in this topic

Hi everyone,

I am new to AutoIT and have been able to find lots of great help on this forum and I thank everyone for it. I am stuck at a problem and not sure where to start looking.

I am trying to read a value on an IE page.

First, I read the web page using _IETagNameAllGetCollection($oIE) and find the string I am looking for using StringInStr function. My problem is that I don't know to to read the number after string is found.

I am searching for "WorkLogTable" using StringInStr command. I need to find a way to read the number right after it.

This is what the line looks like:

z2PL_WorkLogTable5 entries returned - 5 entries matchedPreferences Refresh

I need a way to return the number 5 back to me.

I am not sure how to return this number, any help anyone can provide would be great.

Thanks

Share this post


Link to post
Share on other sites



StringInString gives you the position where in the string "WorkLogTable" starts. Lets say you get 6 as a result. Add the length of "WorkLogTable" and you know where the first digit is.

$iStart = StringInStr($sString, "WorkLogTable")
$iStart = $iStart + 12
$iNumber = StringMid($sString, $iStart, 1)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

...in case there is a potential for more than a single digit's worth of returns:

$sString = "z2PL_WorkLogTable109 entries returned - 109 entries matchedPreferences"

$num = stringregexp($sString , "WorkLogTable(d+)", 3)

msgbox (0, '' , $num[0])
Edited by boththose

,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Share this post


Link to post
Share on other sites

Thanks for such quick response and helpful tips. It works great.

Here is how I used your code.

Local $oElements = _IETagNameAllGetCollection($oIE)
For $oElement In $oElements
If StringInStr($oElement.innerText, "WorkLogTable", 0) > 0 Then
  $s_string = $oElement.innerText
  $num = stringregexp($s_string, "WorkLogTable(d+)", 3)
  msgbox (0, '' , $num[0])
  ExitLoop
EndIf
Next

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0