Outlook csv Files

Gregory Grimes gpgrimes at suddenlink.net
Tue Aug 22 19:18:49 EDT 2017


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
helpdesk at xxxxxxx.com <mailto:helpdesk at 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.


More information about the Python-list mailing list