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
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
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 freelancers are bidding on average €43 for this job
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.
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..??