oemript Posted June 11, 2019 Share Posted June 11, 2019 (edited) Referring to following linked image, it is using post method, I would like to know on how to collect text using AutoIT as shown below: 1) select Jul month and 2019 year 2) click go 3) save text into D:\text1.txt Does anyone have any suggestions? Thanks in advance for any suggestions https://www.moontracks.com/daily-declinations.html Edited June 11, 2019 by oemript Link to comment Share on other sites More sharing options...
jchd Posted June 11, 2019 Share Posted June 11, 2019 Two ways to do it, basically: 1) write a script and use IE* function to automate the selection and grab data. 2) select MM/YYYY and select the table using your mouse, copy-paste in a text editor and save as .TSV file. I've done 2) for you up to 2019-12 in the attached file. This pedestrian but you just spend 5 minutes each year and that should work even if the web page structure changes over time. Decl.tsv oemript 1 This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
FrancescoDiMuro Posted June 11, 2019 Share Posted June 11, 2019 @oemript You can follow this list to have the job done (by yourself obviousely): Use IE UDF as you already did in the past; Same as above; Use File* functions to save whatever you want wherever you want. Click here to see my signature: Spoiler ALWAYS GOOD TO READ: Forum Rules Forum Etiquette Link to comment Share on other sites More sharing options...
oemript Posted June 11, 2019 Author Share Posted June 11, 2019 Thank you very much for suggestions (^v^) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now