CSV backend

[elliotchance]

No description provided.

[elliotchance]

people.csv:

First name,Started,Salary
Bob,21 Jun 2007,80000
Jane,4 Apr 2011,105000
Cathy,17 Mar 2019,
John,18 Sep 2018,45000

average-salaries.bento:

Average salary for file path (path is text):
  Declare people-file as csv file
  Declare person as csv record
  Declare total-salaries as a number
  Declare total-people as a number
  Declare salary as a number
  Declare average-salary

  Open csv file path as people-file
  Until people-file has no more records do
    Read next record from people-file into person
    Set salary to person column "Salary"

    # Only include salaries that are known.
    Unless salary is zero do
      Add salary to total-salaries
      Increment total-people
    Done
  done

  Divide total-salaries by total-people into average-salary
  Display average-salary as currency

$ bento average-salaries.bento -- average salary for file "people.csv"
$76666.67