Завершен

Develop a script or macro to convert .dat file to excel file

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

0000030813504600000308135046

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.

etc.

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.

Thank you.

Навыки: Excel, Visual Basic, PHP, Архитектура ПО, Обработка данных

Показать больше: convert dat database file excel, macro convert dat file excel file, macro convert csv excel, macro copy paste excel file, convert dat flx file excell, script move files using excel file, convert dat xls file aspnet, convert report excel file oracle application, macro copying conten excel file, convert dat excel free, macro convert xls excel, convert dat excel file, excel macro convert tab text file

О работодателе:
( 52 отзыв(-а, -ов) ) Montreal, Canada

ID проекта: #26339809

Поручен:

(547 отзывов(-а))
7.6

17 фрилансеров(-а) готовы выполнить эту работу в среднем за $127

(969 отзывов(-а))
8.1
mtdevil369

Hi, Greetings! ✅checked your project details :Develop a script or macro to convert .dat file to excel file ✅Completed Time : 24 hours or your requirement deadline . I would like to work on your project and want to be Больше

$100 USD за 1 день
(274 отзывов(-а))
6.8
finecodervw

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

$60 USD за 3 дней(-я)
(207 отзывов(-а))
6.6
expertcoder1vw

Hi, I'm an expert Windows database application developer with experience in developing data file parsing to XLS conversion applications. Per your requirements, I am bidding to develop a standalone Windows EXE applica Больше

$250 USD за 4 дней(-я)
(76 отзывов(-а))
6.3
DavidLindon

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.

$56 USD за 2 дней(-я)
(48 отзывов(-а))
6.3
peacemarketing

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.

$155 USD за 3 дней(-я)
(29 отзывов(-а))
5.7
writingapp

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

$80 USD за 2 дней(-я)
(58 отзывов(-а))
5.5
nizamfarhas

⭐⭐⭐⭐⭐ Hello Your requirements: "Develop a script or macro to convert .dat file to excel file" I'm a senior PHP developer with 9 years of experience and I'm very familiar with API integration. I will make your websit Больше

$140 USD за 4 дней(-я)
(14 отзывов(-а))
5.2
$156 USD за 3 дней(-я)
(2 отзывов(-а))
1.6
edigeabdikarim

Hello I have gone through your project detail. On my understanding I am sure that I can help you in this job. I have rich experience of developing Applications using C/C++ and Java with different kinds of APIs. Ple Больше

$200 USD за 7 дней(-я)
(2 отзывов(-а))
1.2
svnkmaity8

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

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
vvoloho

Hello, Magiel I have read your description and I can convert dat file to excel I am C#, Visual Basic expert with rich experience I am very good at Desktop app building so I am sure I can deliver this project in your ti Больше

$100 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
tooklook

hello, i am doing all work in computer and i am interested in this project or i complete this project in the time

$145 USD за 8 дней(-я)
(0 отзывов(-а))
0.0
typo3top

I will make a script for you so you can reuse after.

$140 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
sumon355

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

$120 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
venkateshjuratag

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

$35 USD за 2 дней(-я)
(0 отзывов(-а))
0.0