Formatting timestamps from DD-MM-YYYY to YYYY-MM-DD

An example of how to format timestamps with flux.

import "csv"

import "strings"

csvData =

"

Datum,Watt

30.06.2022,1.24

01.07.2022,1.46

02.07.2022,0.0

03.07.2022,0.0

04.07.2022,0.0

05.07.2022,0.0

06.07.2022,1.35

07.07.2022,3.83

"

data = csv.from(csv: csvData, mode: "raw")

data

|> map(fn: (r) => ({ r with _value: "${strings.split(v: r.Datum, t: ".")[2]}-${strings.split(v: r.Datum, t: ".")[1]}-${strings.split(v: r.Datum, t: ".")[0]}" }))

|> toTime()