Hi, new to forum so advanced apologies if anything in my post is out of place, or unclear.

I have some extemely large dumps of data that I need to sort from their present format into something more user friendly. The three examples below are from 11000+ I'm dealing with.

at_case_id 61626
ca_case_ref LON/00AH/OCE/2014/0295
at_created_dt 2014-12-03 13:26:46
at_audit_type WORDCREATE
at_audit_note Dir/Resp (McMillan Williams Solicitors)
at_user_id 187

at_case_id 61626
ca_case_ref LON/00AH/OCE/2014/0295
at_created_dt 2014-12-03 13:39:56
at_audit_type DOCTOCASE
at_audit_note Directions
at_user_id 187

at_case_id 61636
ca_case_ref LON/00AP/OCE/2014/0296
at_created_dt 2014-11-19 17:30:33
at_audit_type NEWCASE
at_audit_note
at_user_id 49

At it's simplest I need to change the data from a column structure into rows. However its currently too big for Excel, so the idea was to use Word to find each field, and copy and paste into a spreadsheet.

I'm able to do this with fields which are a fixed length using the find all and special characters, so for example all the 11000+ "at_case_id" can be found using the search at_user_id^w^#^#^#^#^#.

The problem I am finding is when the fields are of an unfixed length "at_user_id" for example can be either 2 or 3 characters following the tab / whitespace.

Worse still are "at_audit_type" and "at_audit_note" which as the next example show are again an unfixed length and can carry over to another line.

at_case_id 61626
ca_case_ref LON/00AH/OCE/2014/0295
at_created_dt 2014-11-26 14:40:17
at_audit_type SFLPAPTRK
at_audit_note Send 1st Letters (Paper Track) - Letter(s) sent AND replies expe
cted. Move on to Confirm Paper Track or Change Track
at_user_id 187

at_case_id 61626
ca_case_ref LON/00AH/OCE/2014/0295
at_created_dt 2014-11-26 14:43:44
at_audit_type PAPTRKCRMD
at_audit_note PC (Confirm or Change Track) Result = Standard
at_user_id 187

I'm thinking that a need some kind of find which searches the start of each field, ie the "at_case_id" bit and then the end of the data in that particular line. However I'm damned if I know how...

I'd therefore be really grateful if anyone could point/lead me in the right direction.

Cheers,


Ballst