how would one parse the transition log the print a csv file in the following format? I am assuming reg expression would be the best solution just not sure of the correct syntax for my problem. Any help would be appreciated. Thank you.
record ID, entered, 2012/03/06 16:51:18, assigned, 2012/05/31 13:12:15, resolved, 2012/05/31 13:23:12, obsolete, 2013/02/13 10:56:52
Submitted to entered by Ahmed Tawfik (ahmed.tawfik) on 2012/03/06 16:51:18 ... Text ... Transitioned to assigned by Constance Walker (constance.walker) on 2012/05/31 13:12:15 <comments not supplied> ... Text ... Transitioned to resolved by Ricky Parks (ricky.parks) on 2012/05/31 13:23:12 <comments not supplied> ... Text ... Transitioned to obsolete by _change_admin on 2013/02/13 10:56:52