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
