Probably easier to handle in postgres http://stackoverflow.com/a/37538641/461887
select c1[1] as col1,
c1[2] as col2,
c1[3] as col3,
c1[4] as col4,
substr(col5, 2) as col5
from (
select string_to_array((string_to_array(the_column, ' '))[1], '-') as c1,
(string_to_array(the_column, ' '))[2] as col5
from the_table
) t
--
https://mail.python.org/mailman/listinfo/python-list
