I have a .dat file which I need converted to excel. I need a script or macro that I can use on an ongoing basis.
The .dat file adheres to these specifications:
• File Format: fixed-width text file
• Record Length: 301 characters
• Text Qualifier: none
• Line Terminator: carriage return line feed
• Numeric Fields: right justified and zero filled
• Decimal: two decimals implied for all Price and Weight fields
• Date/Time Format: YYYYMMDD
• Field Format Key:
o A, N – Alpha Numeric (Text / String)
o DT – Date / Time
o N – Numeric
Here are a few lines from the .dat file -
00000308050240000003080502405550014262000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009950001695Q39%000099539%IP 2000090120000613N00010101N NYXNN SRT 39%0000250530716PMPP6007 Y Z N21000530716 N
0000030806356100000308063561 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000199500019957REG0001995REGIPY 2002090100010101Y99991231N YYXNN REG REG0000000000000LRZPH322 Y R N22026206051
0000030806359200000308063592 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000229500022957REG0002295REGIPY 2002090100010101Y99991231N YYXNN REG REG0000000000000LRZPH322 Y R N22026206054
I have a complete data specification which should be used to convert the file to excel. The data specification lays out the data fields like this:
Position Length Format Field Name Description
1 1 A,N GTIN This is the Global Trade Item Number Prefix (GTIN). A
2-14 13 A,N EAN EAN or ISBN – 13.
There are about 30 fields, but I am only interested in about 5 of those fields. One of the fields are the sum of a number of those fields (so you have to add the numbers in a number of fields together to make a new field which is the sum of those fields).
The resulting excel file will therefore have 5 columns with the fields I specify.
The . dat file is fairly large: about 57 MB.
17 фрилансеров(-а) готовы выполнить эту работу в среднем за $127
Hi, I am well versed with Excel macro and can use the same to convert the .dat file to Excel. Please share the actual file so that I can have a look. Looking forward to your response. Thanks
I will create a script you can run on a Windows pc to extract the 5 fields from the dat file and create the excel output as required. can you send me the format specification and which fields you need.
Hello. I have a good skill in Excel/VBA, so I'm very interested in your project. I've checked your project carefully and I can do that. Contact me, please. Thank you.
Hi. I have written many automation apps for converting files. Can convert to any Excel templates. Ready to write your project. Will complete within 2 days
I AM READY TO WORK WITH RESPONSIBLITY AND SINCERITY.I HAVE 6 YEARS EXPERIENCE PERSION.I AM SURE THAT I SHALL BE ABLE TO YOUR WORK IF YOU CONSIDER TO YOUR PROJECT. THANK YOU
Hello, As an experienced visual basic developer, i am very much interested to develop a simple tool to convert your dat file to an excel/csv file. Looking forward to have a positive response from you. Thanks
hello sir , I have good experience in Excel and I promise you to provide quality project to you . you just keep on me and I my work very excellent