extract data from txt to database tables or csv
€30-45 EUR
Betalt ved levering
We have 2 kind of files, the txt with the data and the pdf with the rules on how to divide the columns. The roles are different for each txt file. We need a script to do it automatically because there is over 1400 txt files to extract. The end format must be csv of sql
eg.
in the txt there are rows like this:
9999010A 000000017 978EUR000015789 0ATAUT040
9999010ADN000000018 886YER000015811 0YEYEM887
the pdf explain where to put the semicolumn basing it on the number of characters (length):
column 1: Pos. 000 length: 22
column 2: Pos. 022 length: 4
column 3: Pos. 026 length: 3
column 4: Pos. 029 length: 3
column 5: Pos. 032 length: 9
etc.
Projekt ID: #1584638
Om projektet
Tildelt til:
Hello, I can write you this application to do the required work. I'll deliver you source code, binaries and the parsed data if you provide me full files. See more details in the PM. Regards, Danail Dimitrov
25 freelancere byder i gennemsnit €43 timen for dette job
Hello, experienced C# programmer here. If interested please contact me, so we can discuss the details. Best regards.
Hi, I can start right it now. I have rich experiences on java and mysql for 7 years. Regards.
I can provide you with a script which will automatically format your text files according to the specifications in your PDF files. I have over 15 years experience writing scripts for formatting database load files.
Hi, I have 5+ years work experiences on SQL Server. I can help you do it very soon. Best Regards, Garsy
Greetings I could deliver a solution to generate either a .CSV per text file or an MS-Sql Server database with separate tables for each of the text files you choose to process. In the first option I am talking a Flere