Results 1 to 2 of 2

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

Threaded View

  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.

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