Recently Browsing 0 members
No registered users viewing this page.
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"> </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
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.
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!
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
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
Bird Cat 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 ), 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, "[*]", "")