The renewal maintenance has officially ended for Progress iMacros effective November 30, 2023.
This Wiki site will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely, The Progress Team
Demo-Extract-Table
Jump to navigation
Jump to search
Extract complete table with one command and save data to text file.
Version 6
VERSION BUILD=6000524 TAB T=1 TAB CLOSEALLOTHERS URL GOTO=http://www.iopus.com/imacros/demo/v5/extract.htm SIZE X=801 Y=602 TAG POS=1 TYPE=TABLE ATTR=TXT:<SP>CADCHFEURGBPJPYUSD* EXTRACT=TXT 'The SAVEAS statement was added manually to write the extracted table to a file 'The name of the file to store the extracted information to is specified with the FILE= attribute of the SAVEAS command 'The FOLDER=* attribute indicates that the default folder is used. You can specify another folder with FOLDER=c:\yourfolder SAVEAS TYPE=EXTRACT FOLDER=* FILE=mytable_{{!NOW:yymmdd_hhmmss}}.csv
Before Version 6
VERSION BUILD=3500107 'The name of file to store the extracted information is specified with the FILE= attribute of the SAVEAS command 'The FOLDER=* attribute indicates that the default folder is used. You can specify another folder with FOLDER=c:\yourfolder TAB T=1 TAB CLOSEALLOTHERS URL GOTO=http://www.iopus.com/imacros/demo/v5/index.htm ' 'Note: This macro can run in both, IM Browser and the IE-Plugin 'But the EXTRACT button to start the extraction wizard is only in the IM Browser ' TAG POS=1 TYPE=A ATTR=HREF:http://www.iopus.com/imacros/demo/v5/extract.htm ' 'The first seven tables are in the header of the page 'The 8th table is the list of currencies '=> Extract data of **9th** table (POS=9) on page EXTRACT POS=9 ELEM=0 ATTR=<TABLE* ' 'The SAVEAS statement was added manually to write the extracted table to a file '(The alternative way to get the extracted data is the Scripting Interface) SAVEAS TYPE=EXTRACT FOLDER=* FILE=mytable_{{!NOW:yymmdd_hhmmss}}.csv WAIT SECONDS=3 URL GOTO=http://www.iopus.com/imacros/home/msg/ok.htm