%dw 2.0
output application/dw
var cle = readUrl("classpath://examples/flightsAllAirlinesCLE.json", "application/json")

fun shortform(list: Array) = list map {
	id: $.flightCode,
	when: $.departureDate,
	where: $.destination
}

fun normalizeDate (d: String) = d match {
	case amer if (d matches /[A-Z][a-z]{2}.*/) -> 
		d as Date {format: "MMM dd, yyyy"}
	case science if (d matches /\d{4}\/\w{2}\/\w{2}/) -> 
		d as Date {format: "yyyy/MM/dd"}
	else -> d as Date
}

---
shortform(cle.flights) map (f) -> (f - "when") ++ 
	{when: normalizeDate(f.when)}