Aloha! I have a data file (.dat) that has about 3000+ lines of data that has the format for the first few characters
It actual goes to 500 characters in each lines with 70 different fields.
Can someone please help me out and start me out in how to go about parsing the data automatically and put the data in respective fields (or columns) for each item number in Excel? Or maybe the program will automatically create a file (that is delimited that can then be imported into Excel?
Mahalo! I really don't want to count each record byte by byte.
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 x(02) Wholesale buying department
Can someone please help me out and start me out in how to go about parsing the data automatically and put the data in respective fields (or columns) for each item number in Excel? Or maybe the program will automatically create a file (that is delimited that can then be imported into Excel?
Mahalo! I really don't want to count each record byte by byte.
Comment