Group by Web File

The $WebFileGroup function creates a group based on HTTP or FTP requests. It expects a set of delimited values in the answer, one set per line.

The function has following parameters:

  1. Group number. Positive integer.
  2. Column number. Positive integer.
  3. URL starts with 'http' or 'ftp'. String, quotation not required.
  4. (optional) Use data sequentially. 0 or 1. Optional, default is 0 (false). The first row will be used after the last of necessary.
  5. (optional) File values are patterns. 0 or 1. Optional, default is 0 (false).
  6. (optional) Value separator. The default separator is TAB. Use quoted (,) for the comma.

Examples

  1. $WebFileGroup(1,1,http://www.sqledit.com/data/discounts.txt) - specifies 'discounts.txt' from 'http://www.sqledit.com/data' as data source and uses the first column.
    $Group(1,2) - refers to the second column.
  2. $WebFileGroup(1,1,ftp://sqledit.com/countries.txt,0,0,|) - the engine should use pipe as value separator for 'countries.txt' file requested from 'ftp://sqledit.com'.