!COLn

From iMacros

Specifies the column which is used for input. Set n to the column number you want to use.

Contents 1 Value 2 Set By 3 Examples 4 See Also

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.

See Also