as someone who works with languages, this one seems quite manageable i assume you know how to deal with csv. 1 get the cell string 2 split at _____________ that will make you move around mpre easily as this separates in big chunk 3 for the first chunck, you might want to split at , 4 and so on
Abdur-Rahmaan Janhangeer, Mauritius abdurrahmaanjanhangeer.wordpress.com On 23 Aug 2017 03:34, "Gregory Grimes" <gpgri...@suddenlink.net> wrote: > All, > > I have exported Remedy emails from Outlook to a csv file. The issue is > one cell, Body, has information in multiple lines: > > Subject,Body,From: (Name),From: (Address),From: (Type),To: (Name),To: > (Address),To: (Type),CC: (Name),CC: (Address),CC: (Type),BCC: (Name),BCC: > (Address),BCC: (Type),Billing Information,Categories, > Importance,Mileage,Sensitivity > INC000000977622 Assigned : DBA - PKG1 : mbbanms0006.xxxxxxx.com - Alert, > "Remedy Ticket Information > ________________________________ > Date Open > 08/09/17 12:10:57 > Ticket Number > INC000000977622 <http://remedy.xxxxxxx.com/arsys/forms/remedyapp.xxxxxxx. > com/HPD%3AHelp+Desk/Default+User+View/?eid=INC000000938650> > Date Modified > 08/09/17 12:10:57 > Category > Status > Assigned > Priority > High > Short Description > mbbanms0006.xxxxxxx.com - Alert > User Information > ________________________________ > User Name > Remedy SPI > User Login > remedyspi > User Phone > ### > User Email > helpd...@xxxxxxx.com <mailto:helpd...@xxxxxxx.com> > User Department > Staff Information > ________________________________ > Staff Name > Staff Login > Staff Phone > Staff Email > <mailto:> > Staff Department > DBA - PKG1 > Detailed Ticket Information > ________________________________ > Incident Description > Target : mb08dorb Type : Database Instance Host : mbbanms0006.xxxxxxx.com > Info : A session was terminated at time/line number: Wed Aug 09 12:10:10 > 2017/84281. Metric=ORA-01000: maximum open cursors exceeded~ORA-01000: > maximum open cursors exceeded~ORA-01000: maximum open cursors > exceeded~ORA-01000: maximum open cursors exceeded~ORA-01000: maximum open > cursors exceeded~ORA-01000: maximum open cursors exceeded~ORA-01000: > maximum open cursors exceeded~ORA-01000: maximum open cursors > exceeded~ORA-01000: maximum open cursors exceeded~ORA-01000: maximum open > cursors exceeded~ORA-01000: maximum open cursors exceeded~ORA-01000: > maximum open cursors exceeded~ORA-01000: maximum o > Click Here to Access Remedy <http://remedy.xxxxxxx.com/arsys/home> “ > > My question, what is the best way to parse the long Body string to extract > information from this file for analysis? > > Thanks. > -- > https://mail.python.org/mailman/listinfo/python-list > -- https://mail.python.org/mailman/listinfo/python-list
