Outlook csv Files

[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

On 23 Aug 2017 03:34, "Gregory Grimes" <gpgrimes at 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
> 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.
> --
> https://mail.python.org/mailman/listinfo/python-list
>