CSV Files

Edit

General #

A CSV file is a delimited text file that uses a comma to separate values. CSV files consist of data arranged in rows and columns and LioranBoard has the functionality to load, save, set, edit, and manipulate the values within these rows and columns. These values can be saved as variables to be used in any way you want within the LioranBoard environment.


Edit

Create CSV #

Creates a CSV file. Note that the file isn’t saved until the ‘CSV Save’ command is also used.

Box Name Type Description
CSV Name String Name of your CSV
First Column(Name) String Name of the first column


Edit

CSV Save #

Saves your CSV file to a file path of your choice. The file path has to be the full file path of the file, ending with .csv, and currently works best if drive letters are in lowercase. Alternatively, you can use the /$global.main_directory$/ variable to save your CSV to the default directory.

When a CSV file is saved, an extra row appears at the bottom of the file that is used to save your default values. Modifying this extra row in another program may result in your default values not being read properly by LioranBoard.

Box Name Type Description
CSV Name String Name of your CSV.
File Path String File path to save to.


Edit

CSV Load #

Loads a previously created CSV file.

Box Name Type Description
CSV Name String Name of your CSV
File Path String File path to load from


Edit

CSV Delete #

Deletes a CSV file that was previously loaded. This does NOT delete the CSV file from where it is saved to, it merely deletes the CSV data from the buffer space withn LioranBoard. A CSV file that has been loaded cannot be loaded again unless the CSV has been deleted from the buffer space.

Box Name Type Description
CSV Name String Name of your CSV


Edit

CSV Add Columns #

Adds a column to a pre-existing CSV file.

Box Name Type Description
CSV Name String Name of your CSV
New Column Name String Name of new column
Default Value String Value to be filled in the first box in the column


Edit

CSV Add Row #

Adds a new row to an existing CSV file. New row values (names) must be unique and cannot be duplicated.

Box Name Type Description
CSV Name String Name of your CSV
First Box Value(Name) String Value to be filled in the first box in the row


Edit

CSV Delete Column #

Deletes a column from an existing CSV file.

Box Name Type Description
CSV Name String Name of your CSV
Column Name/Number String Name/Number of the column to be deleted


Edit

CSV Delete Row #

Deletes a row from an existing CSV file.

Box Name Type Description
CSV Name String Name of your CSV
Row Name/Number String Name or number of the row to be deleted.


Edit

CSV Get Box #

Retrives a value from a box in an existing CSV file. When retrieving values using ‘Column/Row Name’, the name in the yellow boxes have to be wrapped in “” as the names are strings. If you use Column/Row Number instead, the number you input into the yellow boxes does not have to be wrapped in “”.

When you use column/row numbers, keep in mind the numbers begin with 0,0. The left-most column in a CSV file is is column 0. The first row below the row of column names is row 0.

CSV columns and rows
CSV columns and rows
Box Name Type Description
CSV Name String Name of your CSV
Column Name/Number String Name or number of the column
Row Name/Number String Name or number of the row
Save Variable String The variable to save the box value as


Edit

CSV Set Box #

Sets a value in a box. Functions the same way as ‘Set Local Variable’.

Box Name Type Description
CSV Name String Name of your CSV
Column Name/Number String Name/Number of the column the box is in
Roe Name/Number String Name/Number of the row the box is in
Value String Value to be saved to the box


Edit

CSV Column Find Value #

Finds a value in a specified column. The first box underneath the column title will return a position of ‘0’, and the numbers will increase as you go down the column. LioranBoard will return a valuve of -1 if no match is found in the column.

Box Name Type Description
CSV Name String Name of your CSV
Column Name/Number String Name of the column to search in
Find String Value that you are searching for
Save variable String Variable name to save the position


Edit

CSV Row Find Value #

Box Name Type Description
CSV Name String Name of your CSV


Edit

CSV Sort #

Box Name Type Description
CSV Name String Name of your CSV


Edit

CSV Move Column #

Swaps the position of one column with another. Please note that the left-most column in any CSV (column 0) cannot be moved.

Box Name Type Description
CSV Name String Name of your CSV
Column Name/Number String Name/Number of the column you want to move
Column Name/Number String Name/Numner of the column you want to swap with


Edit

CSV Move Row #

Swaps the position of one row with another.

Box Name Type Description
CSV Name String Name of your CSV
Row Name/Number String Name/Number of the row you want to move
Row Name/Number String Name/Number of the row you want to swap with