Search the Community

Hello all, First time posting; please excuse my noobness as I am self-taught over a short period with very little programming experience. However, I am trying to create a simple program that retrieves college basketball scores from the web, puts them into an array and writes to excel. Ultimately I want to create an additional variable that would be a date range so the program can cycle through many pages and retrieve years worth of information at a time. For now, I am working on a single day. Here is where I am stuck: I want to use _StringBetween to isolate team names while considering whether they are "winners" or "losers". Here is a snippet from the source code i am dealing with: <tr class="winner"> <td><a href="/teams/MIN/2020.html">Minnesota</a></td> <td class="right">118</td> <td class="right gamelink"> <a href="/boxscores/202001050CLE.html">Final</a> </td> </tr> <tr class="loser"> <td><a href="/teams/CLE/2020.html">Cleveland</a></td> <td class="right">103</td> <td class="right">&nbsp; </td> </tr> </tbody> </table> My thought was to use _Stringbetween( '<tr class ="loser> <td>' & @CRLF & '<td><a href="/teams/', '</a></td>') However, i believe I am using the @CRLF out of context. Is there another way to identify page breaks within the stringbetween function? Complete script is attached for reference. Appreciate the help and patience as I try to piece it all together Muchos gracias. basketball scores x2.au3

Hello community I just started to read the Powershell in a month of lunches book, I want to learn Powershell and make Gui's to execute Powershell scripts, I know that AutoIt is capable for a lot of things included Gui's, My question is how to start my journey, I have no prior programming experience, should I learn only powershell first and then jump to AutoIt, and are there any books for AutoIt, and more important where can I find a Gui builder for AutoIt, I read somewhere for KODA but I can't find it. Any help/advice will be much appreciated.

Hello I am relatively new to the world of Microsoft Office and the Excel UDF. I am trying to loop through every row in a spreadsheet and get the text/values from each column in the given row... so far I have looked into the Help file for the Excel UDF and the wiki page for Excel UDF but I have no idea about how this is done ... This is all I have in my script: Global $oExcel = _Excel_Open(False, False, False, False, True) Global Const $sSpreadsheet = @ScriptDir & '\data.xlsx' Global $oSpreadsheet = _Excel_BookOpen($oExcel, $sSpreadsheet, True, False) ; ... I am placing my bet on the _Excel_Range functions... especially _Excel_RangeRead. I don't know how $vRange works so I would be glad if someone can point me in the right direction . What I would ideally like is to get all of the contents of the spreadsheet (it's just a normal text one) in a 2D array. Thanks in Advance!

Hello! I am trying to call my first DLL function but it won't work , I am trying to call GetFinalPathNameByHandle $sFile = @DesktopDir & '\Test.txt' $hFile = FileOpen($sFile) $sFilePath = "" DllCall("Kernel32.dll", "STR", "GetFinalPathNameByHandle", "HANDLE", $hFile, "sz*", $sFilePath) MsgBox(0, 0, @error)Thanks in Advance, TD

Morning It's 5:30 AM and been sitting here staring at the help file but it looks like an alien language to me. I have the following example strings [8]Bird [9]Cat [10]Dog What I want is Bird Cat Dog Now a easy solution would be to just trim it to the left by 3, however there are cases when it could be 4 (example Dog being [10]), so I figured StringRegExpReplace() is what I am going to have to use unless there is a easier/better method. I don't know how or where to start though StringRegExpReplace($String, "[*]", "") Thanks

So I have read a few posts and tried different things but I cant get this working. I have a GUI with a GUICtrlCreateEdit box so I can type in multiple lines. I then want to write all these lines to a html file (as separate lines but all together in one block. The whole script is pretty big, but but these are the bits of code im using. $GUIExtraInfo = GUICtrlCreateEdit("", 10, 65, 250, 80) $vExtraInfo = GUICtrlRead($GUIExtraInfo) If $vExtraInfo > "" Then FileWriteLine($Signature, "<span class=" & ">" & $vExtraInfo & "</span><br />") It all works - and when I use a msg box to read $vExtraInfo I get the text entered as two lines. But when writing to the file it all comes out on the one line. I have tried stringsplit and a few other things but dosent seem to work. Help appreciated Brain wave. Do I a FileWriteLine(........) for each line entered into the GUICtrlCreateEdit???? Not sure how I would implement this.

Need help logging into the web interface of my WhatsUP gold server for an overhead display in our IT dept. Essentially I want the script to open IE, navigate to our servers web address, login to whats up, then kill IE and start the process over. ( only because the web interface times out after about 10 mins and logs you out ) Currently I have this: $user='admin' $pass='squirrel69' #include <IE.au3> Dim $oIE = _IECreate('about:blank', 0, 0) With $oIE .Left = 0 .Top = 0 .Menubar = False .Resizable = False .StatusBar = False .TheaterMode = True .Toolbar = False .Visible = True EndWith _IENavigate($oIE, 'http://srv13app8/NmConsole/CoreNm/User/DlgUserLogin/DlgUserLogin.asp') I AM STUCK please help !!

Pretty sure this is a one line problem on a easiness factor of "1" on a scale from 1-100 with 0 being the easiest... I want to make a re-usable hotkey that spams 1 and 2 when I press it, an cancels when I press it again. Problem is, after I close it once (pressing the hotkey a second time) the script finishes. I want it to recall the hotkey so that I can use it to time and time again. Where do I call the HotkeySet again? HotKeySet("{F1}", "spam") While 1 Sleep(100) WEnd Func spam() $i=0 HotKeySet("{F1}") HotKeySet("{F1}", "quit") Do Send("2") Sleep(50) Send("1") Sleep(50) Send("2") Sleep(650) Until $i=1 EndFunc Func quit() Exit EndFunc

Okay so basically I have another problem with my script again, Not exactly the script it's self but more finding how to add a certain pixel color into it. I've made a few attempts and got it close but not close enough. I'm trying to make the mouse hover over the Pause Button on my Media Player. I'll add the Pixel color into the attachments. If someone could show me how to find the Pixel color in the form of the line "PixelSearch( 0, 0, $i, 768, 0xFF0000, 10 )" then I'd be the most greatful noobie that ever existed misc4.au3