Update a column value in CSV file

1

I am trying to update a column value or inserting a new value in the column. how to do that in eggplant.

3

Given a .csv file called MathInCSV.csv (below)

Seed,Answer
121
895
144

This code will work:

set myConnectionString to {file:ResourcePath("MathInCSV.csv"), type:"csv", writable: "Yes"}

Repeat with each item CurrentRecord of the records of myConnectionString by reference
	log CurrentRecord.Seed
	put sqrt(CurrentRecord.Seed) into CurrentRecord.Answer
	log CurrentRecord.Answer
End repeat