Importing external data; How to manipulate it prior so it imports correctly?

[trademarked]

First off, let me apologize if this is in the wrong forum. I'm new here and I'm not sure where this post might be appropriate.

I'm importing data form a very large .txt file into an excel spreadsheet. The data imports in an unworkable format, and I'm trying to figure out how to best manipulate the external .txt file for a smooth transition. Below is a snippet of the text file. It continues on about 1600 more times after this. The same type of records repeat with the same titles.

Ideally, I'd have a spreadsheet with the different data titles listed in a row at the top, and then I could scroll down through the rows records.

Does anyone have any ideas? Some friends mentioned macros, but I don't really know what those are. Thanks!

Example:

Filing Number: 2009CVM006043

Filing Type: FORCIBLE ENTRY/DETAINER

Action Type: FORCIBLE ENTRY/DETAINER

Unlawful Detainer: YES

Filing Office: MECKLENBURG COUNTY MAGISTRATE COURT

800 E 4TH ST

CHARLOTTE, NC 28202

Filing County: MECKLENBURG

Filing Date: 03/06/2009


DEBTOR INFORMATION


Debtor: SOLUTION LLC

4617G SHARON CHASE

CHARLOTTE, NC 28215

Debtor Type: BUSINESS


CREDITOR INFORMATION


Creditor: FOUR SEASONS PROP MANAGEMENT

[mudraker]

To me it looks like the best method to import it wouldbe via a macro.

Would need a sample copy of the txt file - make sure any private & personal details are removed

[trademarked]

detainer.txt

It's all public record data

[mudraker]

In the file there are sometimes mutiple entries for the same field names e.g Debtor

Who do you want these mutiple entries handled

Can you post an example workbook of how you wopuld like the data displayed within the workbook - entries should be sufficient

As the file is too large to import directly into a Excel 2003 worksheet I am part way through building a macro to manipulate & import the data

[mudraker]

I have the macro built to import the data

Need to add code to elimante any garbage & align same field types under each other - also see my previous reply


this is the code that will allow the data to be imported into columns

Please Login or Register  to view this content.

[trademarked]

In the file there are sometimes mutiple entries for the same field names e.g Debtor

Who do you want these mutiple entries handled

Can you post an example workbook of how you wopuld like the data displayed within the workbook - entries should be sufficient

As the file is too large to import directly into a Excel 2003 worksheet I am part way through building a macro to manipulate & import the data

I'd like the additional Debtor fields to be included in additional columns immediately to the right. Here's a template that shows what I was thinking.

Template.xls