My own trick for dealing with stuff like this is to import into a view. Attach a trigger to the view to reformat the data and insert into the actual table. In this specific case, you can use the `substr` SQL function to retrieve the substring of the data at the proper offsets. For this simple case, importing into a temporary table and then using INSERT to copy the data into the real table is another way, that does not involve using views or triggers.