CSV Lists

Character-separated values - or CSV - are a common method of listing related data, and in KnowledgeKube they are frequently used in expressions. As the name suggests, individual items of CSV data are separated using a specific character, which is usually—but not always—a comma. This character is known as the Column Separator.

The example below shows a single-line CSV whose values are separated by a comma:

A CSV can also consist of several clusters of data - or Rows - like the one shown above, effectively making them a "list of lists". Each row is separated by a character different to the column separator; this is known as the Row Separator.

The following example shows a CSV constructed using commas as column separators, and pipes as row separators:

To make it easier to understand the relationship between the data in the CSV, you could think of it like this:

Or in a tabular form, like this:

Smith	John	john.smith@jsmith.com
Bloggs	Joe	joebloggs@pmail.com
Fry	Philip	jfry3000@planet-express.com

For more information about implementing CSV Data, refer to Populating CSV Lists.