read

read, keyword

The keyword read offers versatile mechanisms to read data from files.

Example:

table Products = with
  [| as Product, as Color, as Price |]
  [| "shirt", "white,grey", 10.50 |]
  [| "pants", "blue", 15.00 |]
  [| "hat", "red", 5.25 |]

show table "My Export" export: "/sample/products.csv" with
  Products.Product
  Products.Color
  Products.Price

Then,

read "/sample/products.csv" as Products with
  Product : text
  Color : text
  Price : number

show table "My Display" a1b3 with
  Products.Product
  Products.Color
  Products.Price

A single script is limited to 5000 input files.