Pulling data from a text file, splitting by fixed column width

[ferynd]

I need to pull a large table of data from a notepad .txt file. Presently, I'm trying to pull it into a new work book, apply the fixed column split, and then copy and paste it over to my work book. Unfortunately this is not working and I've tried so much code now my own macro is just looking convoluted and painful. Any help would be highly appreciated.

I was hoping that the text to column conversion with the array setup would split this appropriately but it's not splitting the data at all. I'm not sure why. If anyone knows, am I just formatting the numbers wrong? I thought the first number was the character start positions and the second was the number of characters to include.

Please Login or Register  to view this content.

[JBeaucaire]

You're close. The first parameter is the character position to the LEFT of the position you want next. The second parameter is data type. 1 is text.

So, to get the first character set of text use (0, 1). If the first set was 5 characters, then the NEXT group will indicate that with (5, 1) which means start with the character after the 5th and use data type 1. Etc.


So maybe:

Please Login or Register  to view this content.

[JBeaucaire]

Thanks for the feedback.

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above and mark this thread as SOLVED. Thanks.