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
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, "[*]", "")
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.
Brain wave. Do I a FileWriteLine(........) for each line entered into the GUICtrlCreateEdit????
Not sure how I would implement this.