Outlook csv Files

[Gregory Grimes]

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
help...@xxxxxxx.com <mailto:help...@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.

[Abdur-Rahmaan Janhangeer]

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

> --
> https://mail.python.org/mailman/listinfo/python-list
>