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
Difference between revisions of "!COLn"
(→Value) |
|||
(3 intermediate revisions by one other user not shown) | |||
Line 4: | Line 4: | ||
Any positive integer greater than 0 and less the !DATASOURCE_COLUMNS. | 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 === | === Examples === | ||
Line 10: | Line 17: | ||
SET !DATASOURCE example.csv | SET !DATASOURCE example.csv | ||
− | |||
SET !DATASOURCE_LINE <nowiki>{{!LOOP}}</nowiki> | SET !DATASOURCE_LINE <nowiki>{{!LOOP}}</nowiki> | ||
URL GOTO=http://www.some_input.com/enter_name.html | URL GOTO=http://www.some_input.com/enter_name.html | ||
Line 16: | Line 22: | ||
<nowiki>TAG POS=1 TYPE=INPUT:TEXT FORM=form1 ATTR=NAME:last_name CONTENT={{!COL2}}</nowiki> | <nowiki>TAG POS=1 TYPE=INPUT:TEXT FORM=form1 ATTR=NAME:last_name CONTENT={{!COL2}}</nowiki> | ||
− | More examples here. | + | More examples here. |
=== See Also === | === See Also === |
Revision as of 09:42, 20 July 2010
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_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.