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.
Last edited by coreagc; 03-07-2013 at 02:36 AM.
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).
Last edited by coreagc; 03-07-2013 at 11:24 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1