Hoi, er is een funtie toegevoegd: "AddCalculatedField".
Die functie laat toe een "berekend" (uit andere velden) veld toe te voegen aan de Csv File.
De interface:
Code:
{
AddCalculatedField adds a new field (or updated an existing field)
with values calculated from already existing fields.
The "FieldDef" has the following formats:
Newfield = Oldfield1 + OldField2 (sum of two fields)
Newfield = Oldfield1 - OldField2 (difference btw two fields)
Newfield = Oldfield1 * OldField2 (product of two fields)
Newfield = Oldfield1 / OldField2 (quotient of two fields)
NewField = OldField1 % OldField2 (percentage: 100 * OldField1 / OldField2)
Newfield = DaySpan(Oldfield1, OldField2) (days between date fields)
Newfield = HourSpan(Oldfield1, OldField2) (hours between date fields)
Newfield = CumulSum(Oldfield) (cumulative sum of a field)
Newfield = AVG(Oldfield) (cumulative average of a field)
NewField = MovingAVG(OldField, Prev, Next) (moving average of a field)
NewField = Delta(OldField) (Difference with the OldField value in the previous record)
NewField = DateToWeekNo(OldField) (converts a date to a weeknumber format "yww.d")
NewField = DateToWeekNoOnly(OldField) (converts a date to a weeknumber format "yww")
NewField = WeekNoToDate(OldField) (converts a weeknumber format "yww.d" or "yww" to a date)
( a Weeknumber has the format "yww.d")
The result of the function:
0 = all fine
1 = "OldField1" does not exist
2 = "OldField2" does not exist
3 = operator not recognized
}
Bookmarks