Relation:read
Reads a relation from a CSV, TAB or JSON file.
Description
read expression
read encoding encodingvariant expression
Parameters
- expression: result must be a valid name with the extensions .csv, .txt or .json
- encodingvariant: utf8, latin1, windowslatin1 or macroman
Examples
| example | comment |
|---|---|
| read "products.csv" | filename must be quoted |
| read encoding latin1 "films.txt" | |
| read "election".year."json" | Global variables can be used |
| read "mytable" | Without extension, a relation is read from memory if it exists |
Comments
There is no path, only the filename. You can only read after having saved the document as .rel file in a folder. The file must be in the same folder. Relation uses a sandbox.
By default, encoding ist utf8. Use encoding only for other encodings.
The files can be CSV, TAB, JSON. See file formats for specifications.
The relations with files are cached during the session. The files are only read again if the modification date has changed between runs.