Mahalo!
I think you and I were on the same page! I tried importing it with the macro recording on and after several times I think I have it all finished the parsing correctly! Thank you sooo much for steering me in the right direction!!!...
tennisfanatic
Last Activity: Mar 1 '07, 02:29 AM
Joined: Feb 28 '07
Location:
-
Thank you for your response. I think I can do it with text import, but how do I automate it every time I get this file (it is a retail store file that has about 500+ fields and headquarters sends the file every week)? There's got to be an easier way.
Mahalo! (Thank you!)...Leave a comment:
-
Parsing data from a .dat file and putting the data into Excel
Aloha! I have a data file (.dat) that has about 3000+ lines of data that has the format for the first few characters
...Code:Position Field Name Length Description 01-14 Item # 9(14) Item Number 15-19 Vendor 9(05) Vender/Manufacturer ID Number 20-44 Model # x(25) Manufacturer Model Number 45-60 UPC 9(16) Universal Product Code 61-62 Buy Dept
No activity results to display
Leave a comment: