Jump to content
Sign in to follow this  
jonson1986

Selection of Language from dropdown menu IE Help

Recommended Posts

jonson1986

Hey,

I'm trying to select language from drop-down menu on a webpage by _IEGetObjById but it's  not working, It mean autoit open the page but unable to select my desired value not even by matching text or by value, I'm looking for kind help...I've pastes my Autoit codes below along with source codes(using ie) of the webpage ;

#include <IE.au3>
$site = "http://example.com/upload"
$oIE = _IECreate($site)
$oDownloadSamples = _IEGetObjById($oIE, "language")
$oDownloadSamplesSelect = _IETagNameGetCollection($oDownloadSamples, "select", "language")
$oDownloadSamplesSelect.focus
_IEFormElementOptionSelect($oDownloadSamplesSelect, "French", 1, "byText")
Sleep (1000)
_IEFormElementOptionSelect($oDownloadSamplesSelect, "2", 1, "byValue")

HTML Codes using IE:

<html>
<head>
<div class="form-row">
<div class="col-7">
<label>Language</label>
<select name="language" class="select" id="language">
<option value="1">English</option>
<option value="2">French</option>
<option value="3">German</option>
<option value="4">Italian</option>
<option value="5">Japanese</option>
<option value="6">Spanish</option>
<option value="7">Russian</option>
<option value="8">Hindi</option>
<option value="9">Arabic</option>
<option value="10">Chinese</option>
<option value="11">Dutch</option>
<option value="12">Finnish</option>
<option value="13">Korean</option>
<option value="14">Norwegian</option>
<option value="15">Portuguese</option>
<option value="16">Romanian</option>
<option value="17">Serbian</option>
<option value="18">Croatian</option>
<option value="20">Polish</option>
<option value="21">Afar</option>
<option value="22">Abkhazian</option>
<option value="23">Afrikaans</option>
<option value="24">Amharic</option>
<option value="25">Assamese</option>
<option value="26">Aymara</option>
<option value="27">Azerbaijani</option>
<option value="28">Bashkir</option>
<option value="29">Belarusian</option>
<option value="30">Bulgarian</option>
<option value="31">Bihari</option>
<option value="32">Bislama</option>
<option value="33">Bengali/Bangla</option>
<option value="34">Tibetan</option>
<option value="35">Breton</option>
<option value="36">Catalan</option>
<option value="37">Corsican</option>
<option value="38">Czech</option>
<option value="39">Welsh</option>
<option value="40">Danish</option>
<option value="41">Bhutani</option>
<option value="42">Greek</option>
<option value="43">Esperanto</option>
<option value="44">Estonian</option>
<option value="45">Basque</option>
<option value="46">Persian</option>
<option value="47">Fiji</option>
<option value="48">Faeroese</option>
<option value="49">Frisian</option>
<option value="50">Irish</option>
<option value="51">Scots/Gaelic</option>
<option value="52">Galician</option>
<option value="53">Guarani</option>
<option value="54">Gujarati</option>
<option value="55">Hausa</option>
<option value="56">Hungarian</option>
<option value="57">Armenian</option>
<option value="58">Interlingua</option>
<option value="59">Interlingue</option>
<option value="60">Inupiak</option>
<option value="61">Indonesian</option>
<option value="62">Icelandic</option>
<option value="63">Hebrew</option>
<option value="64">Yiddish</option>
<option value="65">Javanese</option>
<option value="66">Georgian</option>
<option value="67">Kazakh</option>
<option value="68">Greenlandic</option>
<option value="69">Cambodian</option>
<option value="70">Kannada</option>
<option value="71">Kashmiri</option>
<option value="72">Kurdish</option>
<option value="73">Kirghiz</option>
<option value="74">Latin</option>
<option value="75">Lingala</option>
<option value="76">Laothian</option>
<option value="77">Lithuanian</option>
<option value="78">Latvian/Lettish</option>
<option value="79">Malagasy</option>
<option value="80">Maori</option>
<option value="81">Macedonian</option>
<option value="82">Malayalam</option>
<option value="83">Mongolian</option>
<option value="84">Moldavian</option>
<option value="85">Marathi</option>
<option value="86">Malay</option>
<option value="87">Maltese</option>
<option value="88">Burmese</option>
<option value="89">Nauru</option>
<option value="90">Nepali</option>
<option value="91">Occitan</option>
<option value="92">(Afan)/Oromoor/Oriya</option>
<option value="93">Punjabi</option>
<option value="94">Pashto/Pushto</option>
<option value="95">Quechua</option>
<option value="96">Rhaeto-Romance</option>
<option value="97">Kirundi</option>
<option value="98">Kinyarwanda</option>
<option value="99">Sanskrit</option>
<option value="100">Sindhi</option>
<option value="101">Sangro</option>
<option value="102">Serbo-Croatian</option>
<option value="103">Singhalese</option>
<option value="104">Slovak</option>
<option value="105">Slovenian</option>
<option value="106">Samoan</option>
<option value="107">Shona</option>
<option value="108">Somali</option>
<option value="109">Albanian</option>
<option value="110">Siswati</option>
<option value="111">Sesotho</option>
<option value="112">Sundanese</option>
<option value="113">Swedish</option>
<option value="114">Swahili</option>
<option value="115">Tamil</option>
<option value="116">Telugu</option>
<option value="117">Tajik</option>
<option value="118">Thai</option>
<option value="119">Tigrinya</option>
<option value="120">Turkmen</option>
<option value="121">Tagalog</option>
<option value="122">Setswana</option>
<option value="123">Tonga</option>
<option value="124">Turkish</option>
<option value="125">Tsonga</option>
<option value="126">Tatar</option>
<option value="127">Twi</option>
<option value="128">Ukrainian</option>
<option value="129">Urdu</option>
<option value="130">Uzbek</option>
<option value="131">Vietnamese</option>
<option value="132">Volapuk</option>
<option value="133">Wolof</option>
<option value="134">Xhosa</option>
<option value="135">Yoruba</option>
<option value="136">Zulu</option>
<option value="19">Other</option>
</select>
</div> 
</main>
</body>
</html>

 

Share this post


Link to post
Share on other sites
genius257

Hi @jonson1986.

First of all, in your code you select the "select" element by id, then try to find "select" elements within it. This results in a empty HTML collection.

Also you cannot call focus/OptionSelect on a collection, even if it contained elements. You would need to use a For loop.

Finally here is your answer:

#include <IE.au3>
$site = "http://example.com/upload"
$oIE = _IECreate($site)
$oDownloadSamplesSelect = _IEGetObjById($oIE, "language")
_IEFormElementOptionSelect($oDownloadSamplesSelect, "French", 1, "byText")
_IEFormElementOptionSelect($oDownloadSamplesSelect, "2", 1, "byValue")

 

  • Like 1

Share this post


Link to post
Share on other sites
jonson1986
30 minutes ago, genius257 said:

Hi @jonson1986.

First of all, in your code you select the "select" element by id, then try to find "select" elements within it. This results in a empty HTML collection.

Also you cannot call focus/OptionSelect on a collection, even if it contained elements. You would need to use a For loop.

Finally here is your answer:

#include <IE.au3>
$site = "http://example.com/upload"
$oIE = _IECreate($site)
$oDownloadSamplesSelect = _IEGetObjById($oIE, "language")
_IEFormElementOptionSelect($oDownloadSamplesSelect, "French", 1, "byText")
_IEFormElementOptionSelect($oDownloadSamplesSelect, "2", 1, "byValue")

 

Thanks you so much.

But I've to tell you one thing, there is still some mistake in the code you shared with after implementing this code nothing happen IE not able to select French from the list and I use sleep command as well so IE can easily load the page before move further to select the option but no error but not outcome as well..

Could you please review the codes you shared and help me to make this possible. Thanks.

Share this post


Link to post
Share on other sites
genius257

Hmmm should work. WIth the information provided i have no issues:

#include <IE.au3>
#include <Array.au3>
$oIE = _IECreate()
_IEBodyWriteHTML($oIE, StringRegExp(FileRead(@ScriptFullPath),"(?s)(<[h]tml>.*<\/html>)",1)[0])
$oDownloadSamplesSelect = _IEGetObjById($oIE, "language")
_IEFormElementOptionSelect($oDownloadSamplesSelect, "French", 1, "byText")
;~ _IEFormElementOptionSelect($oDownloadSamplesSelect, "2", 1, "byValue")

#cs
<html>
<head>
<div class="form-row">
<div class="col-7">
<label>Language</label>
<select name="language" class="select" id="language">
<option value="1">English</option>
<option value="2">French</option>
<option value="3">German</option>
<option value="4">Italian</option>
<option value="5">Japanese</option>
<option value="6">Spanish</option>
<option value="7">Russian</option>
<option value="8">Hindi</option>
<option value="9">Arabic</option>
<option value="10">Chinese</option>
<option value="11">Dutch</option>
<option value="12">Finnish</option>
<option value="13">Korean</option>
<option value="14">Norwegian</option>
<option value="15">Portuguese</option>
<option value="16">Romanian</option>
<option value="17">Serbian</option>
<option value="18">Croatian</option>
<option value="20">Polish</option>
<option value="21">Afar</option>
<option value="22">Abkhazian</option>
<option value="23">Afrikaans</option>
<option value="24">Amharic</option>
<option value="25">Assamese</option>
<option value="26">Aymara</option>
<option value="27">Azerbaijani</option>
<option value="28">Bashkir</option>
<option value="29">Belarusian</option>
<option value="30">Bulgarian</option>
<option value="31">Bihari</option>
<option value="32">Bislama</option>
<option value="33">Bengali/Bangla</option>
<option value="34">Tibetan</option>
<option value="35">Breton</option>
<option value="36">Catalan</option>
<option value="37">Corsican</option>
<option value="38">Czech</option>
<option value="39">Welsh</option>
<option value="40">Danish</option>
<option value="41">Bhutani</option>
<option value="42">Greek</option>
<option value="43">Esperanto</option>
<option value="44">Estonian</option>
<option value="45">Basque</option>
<option value="46">Persian</option>
<option value="47">Fiji</option>
<option value="48">Faeroese</option>
<option value="49">Frisian</option>
<option value="50">Irish</option>
<option value="51">Scots/Gaelic</option>
<option value="52">Galician</option>
<option value="53">Guarani</option>
<option value="54">Gujarati</option>
<option value="55">Hausa</option>
<option value="56">Hungarian</option>
<option value="57">Armenian</option>
<option value="58">Interlingua</option>
<option value="59">Interlingue</option>
<option value="60">Inupiak</option>
<option value="61">Indonesian</option>
<option value="62">Icelandic</option>
<option value="63">Hebrew</option>
<option value="64">Yiddish</option>
<option value="65">Javanese</option>
<option value="66">Georgian</option>
<option value="67">Kazakh</option>
<option value="68">Greenlandic</option>
<option value="69">Cambodian</option>
<option value="70">Kannada</option>
<option value="71">Kashmiri</option>
<option value="72">Kurdish</option>
<option value="73">Kirghiz</option>
<option value="74">Latin</option>
<option value="75">Lingala</option>
<option value="76">Laothian</option>
<option value="77">Lithuanian</option>
<option value="78">Latvian/Lettish</option>
<option value="79">Malagasy</option>
<option value="80">Maori</option>
<option value="81">Macedonian</option>
<option value="82">Malayalam</option>
<option value="83">Mongolian</option>
<option value="84">Moldavian</option>
<option value="85">Marathi</option>
<option value="86">Malay</option>
<option value="87">Maltese</option>
<option value="88">Burmese</option>
<option value="89">Nauru</option>
<option value="90">Nepali</option>
<option value="91">Occitan</option>
<option value="92">(Afan)/Oromoor/Oriya</option>
<option value="93">Punjabi</option>
<option value="94">Pashto/Pushto</option>
<option value="95">Quechua</option>
<option value="96">Rhaeto-Romance</option>
<option value="97">Kirundi</option>
<option value="98">Kinyarwanda</option>
<option value="99">Sanskrit</option>
<option value="100">Sindhi</option>
<option value="101">Sangro</option>
<option value="102">Serbo-Croatian</option>
<option value="103">Singhalese</option>
<option value="104">Slovak</option>
<option value="105">Slovenian</option>
<option value="106">Samoan</option>
<option value="107">Shona</option>
<option value="108">Somali</option>
<option value="109">Albanian</option>
<option value="110">Siswati</option>
<option value="111">Sesotho</option>
<option value="112">Sundanese</option>
<option value="113">Swedish</option>
<option value="114">Swahili</option>
<option value="115">Tamil</option>
<option value="116">Telugu</option>
<option value="117">Tajik</option>
<option value="118">Thai</option>
<option value="119">Tigrinya</option>
<option value="120">Turkmen</option>
<option value="121">Tagalog</option>
<option value="122">Setswana</option>
<option value="123">Tonga</option>
<option value="124">Turkish</option>
<option value="125">Tsonga</option>
<option value="126">Tatar</option>
<option value="127">Twi</option>
<option value="128">Ukrainian</option>
<option value="129">Urdu</option>
<option value="130">Uzbek</option>
<option value="131">Vietnamese</option>
<option value="132">Volapuk</option>
<option value="133">Wolof</option>
<option value="134">Xhosa</option>
<option value="135">Yoruba</option>
<option value="136">Zulu</option>
<option value="19">Other</option>
</select>
</div>
</main>
</body>
</html>
#CE

 

  • Like 1

Share this post


Link to post
Share on other sites
jonson1986

Hey,

Thank you so much and now it's also working for me but it's still not working on the to whom I'm trying to make it working because the website is using javascript and when I disabled javascript this code start working and when I enable the java script this code stopped working...could you please guide me how can I make this possible to work the same code under javascript type website scripts instead of on simple html only...my be javascript preventing our script not to change or select the appropriate value.

Have a great time

Edited by jonson1986

Share this post


Link to post
Share on other sites
Melba23

jonson1986,

When you reply, please use the "Reply to this topic" button at the top of the thread or the "Reply to this topic" editor at the bottom rather than the "Quote" button - others know what they wrote and it just pads the thread unnecessarily.

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

 

Share this post


Link to post
Share on other sites
genius257

Hmmm seems difficult without the original page to test on.

I'm guessing that some JavaScript changes some/the HTML on page load.

If the original element is still accessible after the JavaScript is done processing the DOM, the code with a modified selector will be the answer.

If not, you can:

  • modify the value with your own injected JavaScript, but that can be quite tricky.
  • trigger event(s) programmatically maybe with JavaScript if events more than the 'click' event is required.

It is annoying, but hard to avoid.

Edited by genius257

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  

  • Similar Content

    • Seminko
      By Seminko
      Wrote a script that grabs all of the IP addresses from Netflix's IP log, checks the IPs and returns suspicious activity.
      Everything works as it should but only when _IECreate is set to visible. When visible is set to false, it fails to login for some reason.
      Any ideas what might cause it and/or how to circumvent that?
    • nooneclose
      By nooneclose
      I need to send a string of text to this popup and click on the ok button to save it.
      Here is the code I have so far:
      ;Start IE Sleep(7000) $oIE = _IECreate("http://www.google.com") Sleep(500) _IELoadWait($oIE) $hIE = _IEPropertyGet($oIE, "hwnd") ; Get Handle of the IE window Sleep(500) WinSetState($hIE, "", @SW_MAXIMIZE) ;Wait for a browser page load to complete Sleep(3000) _IENavigate($oIE, "https://properURL.com") Sleep(8000) _IELoadWait($oIE) ;Attach to a browser control embedded in another window $oIE = _IEAttach("https://"properURL.com", url") ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $oIE = ' & $oIE & @CRLF & '>Error code: ' & @error & ' Extended code: 0x' & Hex(@extended) & @CRLF) ;### Debug Console Sleep(2000) ;Get the title of the webpage ;Local $wTitle = _IEPropertyGet($oIE, "title") ;MsgBox($MB_SYSTEMMODAL, "Webpage title:", $wTitle) ;Clicks the new button Sleep(3000) _IEAction($nWorkOrderB, "focus") _IEAction($nWorkOrderB, "click") Sleep(5000) ;Store the Element names where the important data will be sent ;Store the long description button Local $wLongDButton = _IEGetObjById($oIE, "m65d795a4-img") ;Store the long Description field id Local $wComments = _IEGetObjById($oIE, "ma6499a9c-rte_iframe") ;Store the ok button id that is in the long description Local $wCommOk = _IEGetObjById($oIE, "m74031266-pb") ;******************************************************************************* ; Send the stored data to the proper field ;******************************************************************************* ;Click the long description button Sleep(300) _IEAction($wLongDButton, "focus") _IEAction($wLongDButton, "click") Sleep(300) ;Sends the Comments Sleep(500) _IEAction($wComments, "focus") _IEAction($wComments, "click") Sleep(500) _IEFormElementSetValue($wComments, "hello darkness my old friend") ;Click the ok button Sleep(500) _IEAction($wCommOk, "focus") _IEAction($wCommOk, "click") Sleep(500)  
      Here is the popup:

    • hemichallenger
      By hemichallenger
      Hello,
      If anyone can help, it would be greatly appreciated. The code is just an example and similar to the issue with an internal webpage. I'm trying to autofill than click the submit button. I get the same error running the script.
      _IEFormElementSetValue, $_IESTATUS_InvalidObjectType
      IEGetObjById, $_IESTATUS_NoMatch
      Is it possible to edit the <textarea></textarea>  field with AutoIt?  If anyone could assist me on how. Than I could have a better understanding and chance in figuring it out on my main script. Thank you
      #include <IE.au3> Local $oIE1 = _IECreate ("https://www.w3schools.com/tags/tryit.asp?filename=tryhtml_textarea") _IELoadWait($oIE1) local $oFormCollection = _IEFormGetCollection($oIE1,0) local $oid = _IEGetObjByid($oFormCollection, "iframeResult") _IEFormElementSetValue($oid, "test") sleep (2000) Local $oIE2 = _IECreate ("https://www.w3schools.com/html/tryit.asp?filename=tryhtml_scripts_intro") _IELoadWait($oIE2) $oForm2 = _IEFormGetCollection($oIE2,0) $oClickMe = _IEGetObjById($oForm2, "demo") _IEAction($oClickMe, "focus") _IEAction($oClickMe, "click")
    • Blueman
      By Blueman
      Hey Guys,
      Hope that you can help me with something, maybe this is a bug in the new version of AUTOIT but first i will check it with you to know for sure.
      I have made a simple GUI with a Embedded IE Object, then i would like to read the HTML with _IEBodyReadHTML(), easy right?
      When i use the old IE.au3 include from a year back or so, it is working fine!
      When i use the new IE.au3 include came with the new installation that is currently available on autoitscript.com it isnt working (i get a result that says; 0).
      Let me show you.
       
      Working Example
      #include <GUIConstantsEx.au3> #include <IE_EmbeddedVersioning.au3> #include <IE_PreVersion.au3> ;Older Version Example() Func Example() ; Create a GUI with various controls. Local $hGUI = GUICreate("Example", 1000, 1000) Local $idOK = GUICtrlCreateButton("OK", 310, 370, 85, 25) Global $oIE_1 = _IECreateEmbedded() ; CREATE IE OBJECT(S) GUICtrlCreateObj($oIE_1, 355, 5, 600, 360) _IENavigate($oIE_1, "https://www.google.nl", 1) Local $CheckHTML_T = _IEBodyReadHTML($oIE_1) ; Display the GUI. GUISetState(@SW_SHOW, $hGUI) MsgBox(48,"",$CheckHTML_T) ; Loop until the user exits. While 1 Switch GUIGetMsg() Case $GUI_EVENT_CLOSE, $idOK ExitLoop EndSwitch WEnd ; Delete the previous GUI and all controls. GUIDelete($hGUI) EndFunc ;==>Example  
      Failing Example
      #include <GUIConstantsEx.au3> #include <IE_EmbeddedVersioning.au3> #include <IE.au3> ;New Version Example() Func Example() ; Create a GUI with various controls. Local $hGUI = GUICreate("Example", 1000, 1000) Local $idOK = GUICtrlCreateButton("OK", 310, 370, 85, 25) Global $oIE_1 = _IECreateEmbedded() ; CREATE IE OBJECT(S) GUICtrlCreateObj($oIE_1, 355, 5, 600, 360) _IENavigate($oIE_1, "https://www.google.nl", 1) Local $CheckHTML_T = _IEBodyReadHTML($oIE_1) ; Display the GUI. GUISetState(@SW_SHOW, $hGUI) MsgBox(48,"",$CheckHTML_T) ; Loop until the user exits. While 1 Switch GUIGetMsg() Case $GUI_EVENT_CLOSE, $idOK ExitLoop EndSwitch WEnd ; Delete the previous GUI and all controls. GUIDelete($hGUI) EndFunc ;==>Example  
      I have attachted all files and i am testing on Windows 10 with the latest SciTe Program (Not compiled). 
      When i compile the script it is showing the same result.
      Thanks guys!
      IE_PreVersion.au3
      IE.au3
      IE_EmbeddedVersioning.au3
    • rm4453
      By rm4453
      I have a table I am parsing, to find specific vehicle information. I am unable to get _ArrayFindAll to return the only valid result with my test data.
      Below is a sample of the table's HTML:
      <td class="textCenter">2010</td> <td>TOYOTA</td> <td>TACOMA 4X4 DB</td> <td></td> <td>BLACK</td> <td class="textCenter">C</td> <td class="textCenter">6</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">80,975</td> <td class="textRight" nowrap="nowrap">$16,800</td> </tr> <tr><!-- 308 --> <td class="textCenter">2010</td> <td>TOYOTA</td> <td>TACOMA 4X4 RG</td> <td></td> <td>BLACK</td> <td class="textCenter">R</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">5</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">95,224</td> <td class="textRight" nowrap="nowrap">$9,500</td> </tr> <tr><!-- 309 --> <td class="textCenter">2011</td> <td>BUICK</td> <td>REGAL</td> <td>CXL RL4</td> <td>BLACK</td> <td class="textCenter">4</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter"></td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">SR</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">102,694</td> <td class="textRight" nowrap="nowrap">$5,000</td> </tr> <tr><!-- 310 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>AVALANCH 4X4 CR</td> <td>LS</td> <td>GRAY</td> <td class="textCenter">C</td> <td class="textCenter">8</td> <td>E</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">64,759</td> <td class="textRight" nowrap="nowrap">$16,300</td> </tr> <tr><!-- 311 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>EQUINOX AWD 4C</td> <td>LT W/2LT</td> <td>BLACK</td> <td class="textCenter">S</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">AWD</td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">SR</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">91,896</td> <td class="textRight" nowrap="nowrap">$4,400</td> </tr> <tr><!-- 312 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>TAHOE 4X4 V8</td> <td>LTZ</td> <td>WHITE</td> <td class="textCenter">S</td> <td class="textCenter">8</td> <td>C</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>N</td> <td class="textCenter">MR</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">126,982</td> <td class="textRight" nowrap="nowrap">$17,800</td> </tr> <tr><!-- 313 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>1500 SLV 4X4 EX</td> <td>LT</td> <td>GRAY</td> <td class="textCenter">X</td> <td class="textCenter">8</td> <td>GAS</td> <td class="textCenter">O</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">60,303</td> <td class="textRight" nowrap="nowrap">$18,100</td> </tr> <tr><!-- 314 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>1500 SLV 4X4 EX</td> <td>LT</td> <td>SILVER</td> <td class="textCenter">X</td> <td class="textCenter">8</td> <td>E</td> <td class="textCenter">O</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">89,403</td> <td class="textRight" nowrap="nowrap">$15,900</td> </tr> <tr><!-- 315 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>1500 SLV 4X4 EX</td> <td>LTZ</td> <td>BLUE</td> <td class="textCenter">X</td> <td class="textCenter">8</td> <td>E</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">53,087</td> <td class="textRight" nowrap="nowrap">$17,700</td> </tr> <tr><!-- 316 --> <td class="textCenter">2011</td> <td>CHEVROLET</td> <td>3500 CUTAWAY</td> <td>WORK VAN</td> <td>WHITE</td> <td class="textCenter">S</td> <td class="textCenter"></td> <td></td> <td class="textCenter">A</td> <td class="textCenter">4X2</td> <td class="textCenter"></td> <td>N</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">202,477</td> <td class="textRight" nowrap="nowrap">$2,700</td> </tr> <tr><!-- 317 --> <td class="textCenter">2011</td> <td>CHRYSLER</td> <td>TOWN &amp; COUNTRY</td> <td>TOURING</td> <td>BLACK</td> <td class="textCenter">4</td> <td class="textCenter">6</td> <td>E</td> <td class="textCenter">A</td> <td class="textCenter">4X2</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter"></td> <td class="textRight" nowrap="nowrap">198,541</td> <td class="textRight" nowrap="nowrap">$1,900</td> </tr> <tr><!-- 318 --> <td class="textCenter">2011</td> <td>DODGE</td> <td>DURANGO AWD V6</td> <td>CREW</td> <td>BLUE</td> <td class="textCenter">S</td> <td class="textCenter">6</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">AWD</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">SR</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">176,036</td> <td class="textRight" nowrap="nowrap">$2,800</td> </tr> <tr><!-- 319 --> <td class="textCenter">2011</td> <td>FORD</td> <td>FOCUS</td> <td>SE</td> <td>SILVER</td> <td class="textCenter">4</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter"></td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">101,929</td> <td class="textRight" nowrap="nowrap">$3,100</td> </tr> <tr><!-- 320 --> <td class="textCenter">2011</td> <td>FORD</td> <td>FUSION FWD 4C</td> <td>SEL</td> <td>WHITE</td> <td class="textCenter">4</td> <td class="textCenter">4</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter"></td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">SR</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">78,290</td> <td class="textRight" nowrap="nowrap">$5,500</td> </tr> <tr><!-- 321 --> <td class="textCenter">2011</td> <td>FORD</td> <td>F150 4X4 CR</td> <td>XLT</td> <td>BLACK</td> <td class="textCenter">C</td> <td class="textCenter">8</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">4X4</td> <td class="textCenter">Y</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">70,909</td> <td class="textRight" nowrap="nowrap">$16,000</td> </tr> <tr><!-- 322 --> <td class="textCenter">2011</td> <td>FORD</td> <td>MUSTANG V6 CPE</td> <td>V6 PREMIUM</td> <td>BLACK</td> <td class="textCenter">2</td> <td class="textCenter">6</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter">4X2</td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">L</td> <td class="textRight" nowrap="nowrap">92,531</td> <td class="textRight" nowrap="nowrap">$2,700</td> </tr> <tr><!-- 323 --> <td class="textCenter">2011</td> <td>GMC</td> <td>ACADIA FWD</td> <td>SLE</td> <td>RED</td> <td class="textCenter">4</td> <td class="textCenter">6</td> <td>GAS</td> <td class="textCenter">A</td> <td class="textCenter"></td> <td class="textCenter">A</td> <td>CD</td> <td class="textCenter">HT</td> <td class="textCenter">C</td> <td class="textRight" nowrap="nowrap">79,199</td> <td class="textRight" nowrap="nowrap">$10,700</td> A picture of the table test data is attached here:

      Here is the _query function, and all other relevant code that I can share.
       
      Func _query($aSel, $aUrls) $oIE = _login() If $oIE = "Return" Then Return EndIf $j = 0 While $j < UBound($aSel) - 1 $i = 1 $aucID ;Unable To Share What This Is Other Than Var Name. _IENavigate($oIE, "Something" & $aucID[0] & "Something") _IELoadWait($oIE, 100, 2000) $oObj = _IETableGetCollection($oIE, 3) $cars = _IETableWriteToArray_ProgressBar($oObj, True, "Processing Requested Information!") ;<---- Modified Version See Post For It: https://www.autoitscript.com/forum/topic/195335-solved-how-to-add-a-progress-bar-to-_ietablewritetoarray/?tab=comments#comment-1400699 $carsYear = _filter($cars, 0, 0, GUICtrlRead($year)) $carsMake = _filter($carsYear, 0, 1, GUICtrlRead($make)) Global $carsModel = _filter($carsMake, 0, 2, GUICtrlRead($model)) $i = 0 $engine = GUICtrlRead($engine) If $engine <> "" Then While $i < StringLen($engine) $carsEngine = _filter($carsModel, 0, 6 + $i, StringLeft($engine, 1)) ;_ArrayDisplay($carsModel, "Cars Model Before Array Delete") $x = 1 While $x <= UBound($carsModel) _ArrayDelete($carsModel, $x) $x += 1 WEnd ;_ArrayDisplay($carsModel, "Cars Model After Array Delete") ;_ArrayConcatenate($carsModel, $carsEngine) ;_ArrayDisplay($carsModel, "Cars Model After Concatenate") $engine = StringTrimLeft($engine, 1) $i += 1 WEnd Else Dim $carsEngine[1][16] EndIf _ArrayConcatenate($carsEngine, $carsModel) _ArrayDisplay($carsEngine, "Cars Engine") Dim $carsDriveTrain[1][16] Dim $carsDriveTrain2[1][16] $driveTrainVal = GUICtrlRead($driveTrain) If $driveTrainVal = "4x4" Or $driveTrainVal = "awd" Then $carsDriveTrain = _filter($carsEngine, 0, 9, "4") $carsDriveTrain2 = _filter($carsEngine, 0, 9, "a") ;~ _ArrayDisplay($carsDriveTrain, "Drive Train Before") ;~ If @error Then ;~ MsgBox("", "", "Cars Drive Train Error: " & @error) ;~ EndIf ;~ _ArrayDisplay($carsDriveTrain2, "Drive Train2 Before") ;~ If @error Then ;~ MsgBox("", "", "Cars Drive Train 2 Error: " & @error) ;~ EndIf _ArrayConcatenate($carsDriveTrain, $carsDriveTrain2) _ArrayDisplay($carsDriveTrain, "Drive Train After Concat") ElseIf $driveTrainVal = "" Then _ArrayConcatenate($carsDriveTrain, $carsEngine) Else $carsDriveTrain = _filter($carsEngine, 0, 9, $driveTrain) EndIf Dim $carsOdom[1][16] $min = GUICtrlRead($odomMin) $max = GUICtrlRead($odomMax) For $i = 0 To UBound($carsDriveTrain) - 1 If $carsDriveTrain[$i][14] > $min And $carsDriveTrain[$i][14] < $max Then _ArrayAdd($carsOdom, $carsDriveTrain[$i]) MsgBox("", "", "ADDED!") EndIf Next _ArrayDisplay($carsOdom, "Cars Odom") $j += 1 WEnd _IEQuit($oIE) EndFunc ;==>_query Func _filter($tofilter, $xpos1, $ypos1, $str) ;~ If UBound($tofilter, 1) <= 1 Then ;~ $endx = 0 ;~ Else ;~ $endx = UBound($tofilter, 1) - 1 ;~ EndIf ;~ $cars = _ArrayFindAll($tofilter, $str, $tofilter[$xpos1][$ypos1], $tofilter[$endx][$ypos1], 0, 1, $ypos1, False) $cars = _ArrayFindAll($tofilter, $str, Default, Default, 0, 1, $ypos1) Dim $carsFiltered[1][16] = [["a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p"]] ;_ArrayDisplay($carsFiltered) $i = 0 $uBound = UBound($cars) - 1 While $i < $uBound $filtered = _ArrayExtract($tofilter, $cars[$i], $cars[$i], 0, 15) ;_ArrayDisplay($filtered, "_filter Array of Filtered") _ArrayConcatenate($carsFiltered, $filtered) $i += 1 WEnd _ArrayDelete($carsFiltered, 0) Return $carsFiltered EndFunc ;==>_filter  
      If you know of a more efficient way of doing this please let me know would be more than happy to chew down my inefficiency while learning! (It's like my grandpa used to say, "The only criticism I can't use is that which is not given to me.")
       
      The Item an I am using to test the filter is:

       
×