Python-сообщество

mystr = 
"""EXPECTED:
SQL: 
    select * from my_table

ACTUAL:
PLSQL:
    begin 
        DBMS_OUTPUT.put_line(mypckg.myfunc (256));
    end;

MSG:
MSG_FAIL: FAIL
MSG_PASS: PASS"""

dict({'EXPECTED' : {'SQL' : 'select * from my_table'}, 'ACTUAL' : {'PLSQL' : 'begin DBMS_OUTPUT.put_line(mypckg.myfunc (256)); end;'}, 'MSG' : {'MSG_FAIL' : 'FAIL' , 'MSG_PASS' : 'PASS'}})

mystr ="""EXPECTED:
SQL: 
    select * from my_table

ACTUAL:
PLSQL:
    begin 
        DBMS_OUTPUT.put_line(mypckg.myfunc (256));
    end;

MSG:
MSG_FAIL: FAIL
MSG_PASS: PASS"""
mystr = mystr.replace("\n\n",":")
mystr = mystr.replace("MSG_PASS",":MSG_PASS")
rlist=mystr.split(":")
mylist = [line.strip().replace("\n","") for line in rlist]

print mylist

['EXPECTED', 'SQL', 'select * from my_table', 'ACTUAL', 'PLSQL', 'begin         DBMS_OUTPUT.put_line(mypckg.myfunc (256));    end;', 'MSG', 'MSG_FAIL', 'FAIL', 'MSG_PASS', 'PASS']