Jump to content

Extract number from HTML and paste it into the form


Recommended Posts

Hello, how to extract data from HTML and paste it into a certain field on a web site?

The necessary HTML code as follows (the number may vary):

<td class="bd" align="right"><!-- Balance Start -->100600.66<!-- Balance End --></td>

subtracted from the number 100.00 and insert in the

$oInput =_IEGetObjByName($oIE,"sum")
_IEFormElementSetValue ($oInput, '100500.66')
Link to comment
Share on other sites

  • Moderators

aleksandrovich,

Welcome to the Autoit forum. :)

I would use a RegExReplace like this: ;)

$sText = '<td class="bd" align="right"><!-- Balance Start -->100600.66<!-- Balance End --></td>'

; Extract the number - using a RegEx means we can ignore the actual number of digits
; We use Number to get the variable into the correct type
$nNumber = Number(StringRegExpReplace($sText, ".*Balance Start -->(d*.d*)<!-- Balance End.*", "$1"))

; Which means we can easily do arithmetic here
ConsoleWrite(($nNumber - 100) &amp; @CRLF)

The RegEx works like this:

.*                 - Any number of characters
Balance Start -->  - Followed by this string
(d*.d*)         - Here we capture any number of digits, a decimal point and then any more digits
<!-- Balance End   - Until we find this string
.*                 - Followed by any other characters

$1                 - And we replace the whole string with the captured decimal number

Please ask if you have any questions. :)

M23

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...