kubernetes/xactmon/commerce.awk

/ending in/ {
	gsub(/^ +/, "");
	account=$0
}

/•/ {
	if (date=="") {
		gsub(/[^0-9-]+/, "");
		date=$0
	} else if (description == "") {
		gsub(/.*• /, "")
		description=$0
	} else if (amount == "") {
		gsub(/[^0-9.]+/, "");
		amount=$0
	}
}

END {
	OFS="|"
	print(account, date, amount, description)
}