Importing delimited text into columns vice rows

If you can provide a sample of two of the text files, the files don't need to have a lot of data, a few sample addresses in each, and also an Excel workbook showing the exact results expected from those two sample text files, we can probably set you up with an import macro.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi..

There is probably a more elegant way of allocating the values to the xx array.. but this will do the job and should be quick.

Npte: This assumes your text files are same format as the block of data you posted in the 1st post.

Please Login or Register  to view this content.

Thank you for the speedy replies. I can’t post the actual data fields or a sample of the data, it is proprietary. I will try to explain in more detail what I would like to do.

I have looked at the code that apo posted and it looks promising just needs to be tweeked a bit for my application.

Block = entire data set between solid lines.
Item = line of text with unique title to the left of colon and unique data to the right of colon

I have multiple text files that contain multiple sections with 12 different pieces of data. I only wish to do one text file per import. The data is formatted like in my example of the address below, (but there are 12 different lines). Each 12 item block, is separated by a solid line (which I don’t need to import). Each block of 12 items contains the same title to the left of the colon but different data to the right. The data to the right of the colon could be a paragraph of text or a single number, it is variable.
____________________________
Name: Joe Smith
Address: 123 S. Street
City: New York
Phone: 1231231234
____________________________
Name: Sam Jones
Address: 321 S. Street
City: New York
Phone: 3213214321
____________________________

What I would like to do is have the data to the left of each colon as my column headings. There will be 12 which I can set up ahead of time in my template, it will never change. Then I would like to pull the data to the right of each colon and populate the appropriate data under each heading starting on row 2 so it looks like this”

A B C D
1Name Address City Phone
2Joe Smith 123 S. Street New York 1231231234
3Sam Jones 321 S. Street New York 3213214321

The goal of this is to be able to sort and filter the data based on the content of each column.

I hope this makes what I am trying to do clearer.

Thanks
Scott

Please find a sample text file and an example workbook with desired results attached.

Example of workbook.xlsx
sample text file.txt


Once again thank you for all the assistance.

Scott