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