Given that your data is quite irregular (some fields are empty on some records), split is probably not the best for this task. The substr or unpack functions are probably better candidates to easily extract data from fixed-length fields/records.