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")
ArgumentMeaning
sourceThe value to filter, such as raw.
fieldThe column to test, written unquoted.
valueThe 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])
ArgumentMeaning
sourceThe value to narrow, such as active.
fieldsA 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")
ArgumentMeaning
sourceThe value to write out.
pathDestination 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.