+ Reply to Thread
Results 1 to 2 of 2

Import txt to table issue with new lines created when not EOL

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    atherton, qld, australia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Import txt to table issue with new lines created when not EOL

    I am importing some text data from a set of files I have created in python (converting metadata/xml records to text) into excel. It mostly works fine except that there are new lines inserted at points where the text is simply in a paragraph. Is it possible to get excel to automatically maintain data in the same row until it meets an escape/new character?

    I have attached

    1. anz*_log.txt -- Raw text file where I am using "^" as the delimiter. I can force it to add another character at the end of each known row if excel can use this to only create new lines when this exists.
    2. anz*_xml.xls Excel Import - worksheet (*log) the raw import data) and cleaned where I have used formulas to get the values in properly.
    3. rowChar_anz*log.txt - Raw text file with ':;:' at start of each row to show that it should be a new row (same as 1 but with additional delimiter for row)

    This is just on a test dataset and I need to run this on 1000's of files. See the issues in row 9,13, 54 etc.

    best,
    Attached Files Attached Files
    Last edited by coreagc; 03-07-2013 at 02:36 AM.

  2. #2
    Registered User
    Join Date
    02-01-2013
    Location
    atherton, qld, australia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Import txt to table issue with new lines created when not EOL

    I figured out how to resolve this using the python code itself. Final output added for reference. Now my issue is with getting the data sorted in to columns properly as they are not always in the same order (details posted here).
    Attached Files Attached Files
    Last edited by coreagc; 03-07-2013 at 11:24 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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