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
!COLn
Specifies the column which is used for input. Set n to the column number you want to use.
Value
Any positive integer greater than 0 and less the !DATASOURCE_COLUMNS.
Set By
[ ] Internal
[X] SET
Internal means that the iMacros program itself sets the value of the variable during program run. SET means that the user can set this value via the SET command inside a macro.
Examples
In this example the example.csv file holds the first names in the first and the last names in the second column. On a web site we want to insert these values into the appropriate fields.
SET !DATASOURCE example.csv SET !DATASOURCE_COLUMNS 2 SET !DATASOURCE_LINE {{!LOOP}} URL GOTO=http://www.some_input.com/enter_name.html TAG POS=1 TYPE=INPUT:TEXT FORM=form1 ATTR=NAME:first_name CONTENT={{!COL1}} TAG POS=1 TYPE=INPUT:TEXT FORM=form1 ATTR=NAME:last_name CONTENT={{!COL2}}
More examples here.