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"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
=== Examples === | === Examples === | ||
− | In this example | + | 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 example.csv |
Revision as of 10:39, 23 April 2007
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.
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.