extract data from txt to database tables or csv

Closed

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.

Skills: Database Administration, Java, MySQL, SQL

See more: txt database, data txt database, extract data database, extract data csv database, sql pdf files, sql pdf file, txt, pos java, pos data, extract, extract tables, extract from pdf, extract data, data tables, pos sql, sql pos, java txt pdf, extract data pdf csv, csv column format, pdf txt java, pdf extract data, pdf data extract, sql extract data csv, txt pdf, csv pdf

Project ID: #1584638

Awarded to:

gaddas86

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

€45 EUR in 3 days
(23 Reviews)
4.2

25 freelancers are bidding on average €43 for this job

diepbp

I am confident to handle your project. Please check your inbox for details, thank you.

€30 EUR in 1 day
(82 Reviews)
6.0
marchent

i am interested on your project.

€42 EUR in 5 days
(127 Reviews)
5.9
csanuragjain

hi i can do this contact if interested

€30 EUR in 1 day
(23 Reviews)
5.2
victory07

I can do it for you.

€30 EUR in 1 day
(9 Reviews)
4.8
greggfletcher

Hello, experienced C# programmer here. If interested please contact me, so we can discuss the details. Best regards.

€45 EUR in 2 days
(5 Reviews)
4.6
diamond1027

Hi, I can start right it now. I have rich experiences on java and mysql for 7 years. Regards.

€40 EUR in 1 day
(30 Reviews)
4.5
abbie3290

I can write the script for this. Lets start. Thanks, Abbie

€30 EUR in 1 day
(15 Reviews)
4.1
amelnyk

Please see my proposal in inbox

€180 EUR in 1 day
(3 Reviews)
3.3
Alkobazik

Can do the task, plese check details.

€30 EUR in 1 day
(3 Reviews)
3.1
amfuries

################# PLEASE CHECK THE PM ##################

€30 EUR in 1 day
(4 Reviews)
2.8
hfbaker

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.

€30 EUR in 1 day
(1 Review)
2.0
luckyfred

Hi, I have 5+ years work experiences on SQL Server. I can help you do it very soon. Best Regards, Garsy

€40 EUR in 1 day
(1 Review)
1.8
SharanGanesh

Hi, Please send pdf and I am confident that I can do this project.

€40 EUR in 2 days
(1 Review)
1.0
bennyhe

I am familiar with java process CSV and data load to database. I am good at building small Java tools with simple interface.

€30 EUR in 2 days
(0 Reviews)
0.0
East69

OK! I need some details and I can do it.

€60 EUR in 3 days
(0 Reviews)
0.0
shwetankr

Please provide samples of Txt files and PDFs and I will make you a program you require

€30 EUR in 5 days
(0 Reviews)
0.0
JoeGreen1982

Hi, database expert here, with 10 years of experience in projects of this nature. Please check your messages for further info. Many thanks Joe

€30 EUR in 1 day
(0 Reviews)
0.0
amitx14

Please check the PMB.

€30 EUR in 2 days
(0 Reviews)
0.0
karthikeyankes25

i attached a sample jar file based on you requriment.Please execute and if satified accept my bid.

€42 EUR in 2 days
(0 Reviews)
0.0
dondasanjay

It can be done so easily by using bulk load in Oracle and in SQL server as well. first of all need to know that what back end platform you are using Oracle or Ms Sql Server Or My Sql or any other..??

€30 EUR in 2 days
(0 Reviews)
0.0