Statements
These are the statements VeraScript supports today. The Commands button in the editor inserts a template for each one, so you do not have to memorise the argument order.
load.csv
Reads a CSV file from the project into a value.
let raw = load.csv("data/customers.csv")Paths are relative to the project folder you opened. This is normally the first step in a script, and the checkpoint it creates is the one you will rewind to most often — it is usually the most expensive step to repeat.
filter
Keeps only the rows where a field matches a value.
let active = filter(raw, status, "active")| Argument | Meaning |
|---|---|
| source | The value to filter, such as raw. |
| field | The column to test, written unquoted. |
| value | The value to match, in quotes. |
Watch the row count in the inspector after a filter — a large unexpected drop usually means the field name or the value does not match what is actually in the data.
select
Narrows a value to a chosen list of fields.
let report = select(active, [id, name, region])| Argument | Meaning |
|---|---|
| source | The value to narrow, such as active. |
| fields | A bracketed list of columns to keep, in the order you want them. |
Selecting early keeps later steps cheaper and makes the results table easier to read. The column count in the inspector confirms what survived.
export.csv
Writes a value back out to a CSV file.
export.csv(report, "data/active-customers.csv")| Argument | Meaning |
|---|---|
| source | The value to write out. |
| path | Destination path, relative to the project folder. |
Unlike the other statements this one does not bind a value — it is a terminal step. A script can end with several exports if you want more than one output from the same run.
Next: Conventions — quoting, comments and validation.