+ Reply to Thread
Results 1 to 4 of 4

How do I import log info from an email into Excel 2013?

  1. #1
    Registered User
    Join Date
    04-21-2014
    Location
    Carson City, NV
    MS-Off Ver
    Excel 2013
    Posts
    2

    How do I import log info from an email into Excel 2013?

    I receive the below log info from an email. What would be the best way using a VBA script or Macro to import this info into Excel 2013 with appropriate columns? I have copied and pasted the info into a text file and used "Get External Data from file to import into Excel 2013. I'm lost in figuring a way for VBA script or a Macro to enter data into columns with headings across the top. I would like to be able to "flag" some of the data. Like "bytes"..lets say there is a 5%+/- increase/decrease in bytes. I would like for that data to be highlighted in Red as an alert.

    When I used the Get External Data, it worked but the data looks pretty much like what you see below.


    Columns I want to create across top of worksheet.(not necessarily) in the below order:
    Start | End | bytes | files | duration | cluster | sites | script


    Subject: db_backup_pt1_summary

    cluster: dbclust10 (ha10a)
    script: db_backup_pt1 3.3
    sites: 10 selected, 10 rsynced
    start: 2014-04-18 01:30:02
    end: 2014-04-18 03:45:52
    duration: 2.26 hours
    files: 64438 counted, 8945 updated
    bytes: 129.09G counted, 96.51G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: dbclust05 (ha07b)
    script: db_backup_pt1 3.3
    sites: 77 selected, 77 rsynced
    start: 2014-04-18 00:45:01
    end: 2014-04-18 04:55:23
    duration: 4.17 hours
    files: 479746 counted, 17778 updated
    bytes: 214.68G counted, 171.33G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: dbclust06 (ha08a)
    script: db_backup_pt1 3.3
    sites: 61 selected, 61 rsynced
    start: 2014-04-17 23:00:02
    end: 2014-04-18 04:26:28
    duration: 5.44 hours
    files: 388307 counted, 17266 updated
    bytes: 251.41G counted, 198.71G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: dbclust12 (ha04)
    script: db_backup_pt1 3.3
    sites: 2 selected, 2 rsynced
    start: 2014-04-17 23:00:01
    end: 2014-04-17 23:38:50
    duration: .64 hours
    files: 14933 counted, 852 updated
    bytes: 48.10G counted, 29.77G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: dbclust08 (ha09a)
    script: db_backup_pt1 3.3
    sites: 67 selected, 67 rsynced
    start: 2014-04-17 23:00:01
    end: 2014-04-18 03:58:20
    duration: 4.97 hours
    files: 428251 counted, 17042 updated
    bytes: 207.56G counted, 130.59G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: dbclust04 (ha07a)
    script: db_backup_pt1 3.3
    sites: 74 selected, 74 rsynced
    start: 2014-04-17 23:00:01
    end: 2014-04-18 06:10:02
    duration: 7.16 hours
    files: 464192 counted, 18622 updated
    bytes: 347.42G counted, 279.11G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: virtdb02 (ha03)
    script: db_backup_pt1 3.3
    sites: 58 selected, 58 rsynced
    start: 2014-04-17 22:30:02
    end: 2014-04-18 02:31:34
    duration: 4.02 hours
    files: 368836 counted, 14567 updated
    bytes: 171.42G counted, 135.23G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: dbclust13 (ha11b)
    script: db_backup_pt1 3.3
    sites: 2 selected, 2 rsynced
    start: 2014-04-17 22:00:02
    end: 2014-04-17 22:13:42
    duration: .22 hours
    files: 12104 counted, 275 updated
    bytes: 29.02G counted, 17.26G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: dbclust09 (ha09b)
    script: db_backup_pt1 3.3
    sites: 67 selected, 63 rsynced
    start: 2014-04-17 22:00:02
    end: 2014-04-18 02:15:49
    duration: 4.26 hours
    files: 462446 counted, 14348 updated
    bytes: 310.91G counted, 195.66G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: dbclust07 (ha08b)
    script: db_backup_pt1 3.3
    sites: 49 selected, 49 rsynced
    start: 2014-04-17 22:00:01
    end: 2014-04-18 03:18:33
    duration: 5.30 hours
    files: 307453 counted, 16432 updated
    bytes: 181.96G counted, 146.45G transferred error lines: 0
    ---------------------------------------------------------------------
    cluster: virtdb03 (ha06)
    script: db_backup_pt1 3.3
    sites: 74 selected, 74 rsynced
    start: 2014-04-17 21:45:05
    end: 2014-04-18 05:18:28
    duration: 7.55 hours
    files: 453662 counted, 18147 updated
    bytes: 383.74G counted, 311.78G transferred error lines: 0
    ---------------------------------------------------------------------

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,450

    Re: How do I import log info from an email into Excel 2013?

    Why do you copy and paste it into a text file? Why not paste it straight into Excel?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-21-2014
    Location
    Carson City, NV
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: How do I import log info from an email into Excel 2013?

    Sorry I'm a newbie! Ok..I'll paste directly into Excel. However I'm still really looking for a solution that will allow me to format the data as stated in the previous thread? Any ideas?

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,450

    Re: How do I import log info from an email into Excel 2013?

    This works with the sample data in your post, copied and pasted straight into Excel (on Sheet1)

    Please Login or Register  to view this content.

    See the attached example workbook.


    Regards, TMS
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using Excel 2013...looking for code to email page(s) to pre-selected recipients
    By BobbyB0909 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2014, 07:57 PM
  2. Replies: 0
    Last Post: 10-13-2013, 06:28 PM
  3. Import AutoCAD 2013 Drawing into Excel via Macro
    By elowther in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2012, 05:27 PM
  4. Make a sheet with selectable info, send email using info selected
    By DwayneHeight in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2007, 12:18 PM
  5. Import Access Database info to Excel???
    By jwr in forum Excel General
    Replies: 4
    Last Post: 08-16-2005, 01:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1