Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Mar 2010
    Thanked 0 Times in 0 Posts

    perl script to convert multi-line data records in txt file to Excel XLS

    I have a text file report that I need to translate to XLS. There are 2 lines of data for each record that I need to concatenate into one line and then extract the data to map to an XLS excel spreadsheet. See sample below. I want to automate this process as each text file contains 124 pages of data that I need to remap to Excel.

    Token Report Date: 02/12/2010 08:20:19
    All Tokens Page: 1 of 124

    Serial No. User Name Token Status Last Login
    -->Token Type/Auth with/Algorithm Start Date Shutdown Date

    000030470765 Bill Ding Enabled,NewPIN 01/01/1986 00:00:00
    -->Key Fob/Passcode/AES 03/16/2006 00:00:00 08/31/2010 00:00
    000030470766 Joe South Enabled 01/21/2010 19:25:17
    -->Key Fob/Passcode/AES 03/16/2006 00:00:00 08/31/2010 00:00

    Thanks in advance.

  • #2
    New Coder MetalGear's Avatar
    Join Date
    Feb 2008
    Thanked 1 Time in 1 Post
    you can use Spreadsheet::ParseExcel ,Spreadsheet::WriteExcel
    and other related packages, to create and write to an excel file.


    Tags for this Thread

    Posting Permissions

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