split up the record data into arrays