Web File Function
$WebFile function loads text file from specified URL (by HTTP or FTP) or calls web service for a list of data values. The function expects one value per line file format. It has the following parameters:
  1. URL starts from 'http' or 'ftp'. String, quotation not required.
  2. (optional) Use data from the file sequentially. 0 or 1, default is 0 (false). The first row will be used after the last of necessary.
  3. (optional) Values are patterns. 0 or 1, default is 0 (false).

Examples

  1. $WebFile(http://www.sqledit.com/data/sales.txt)
  2. $WebFile(ftp://sqledit.com/sales.txt,1)