Find Jobs
Hire Freelancers

Data Processing fixed-length to CSV

€8-30 EUR

Cancelled
Posted about 10 years ago

€8-30 EUR

Paid on delivery
We have 500 files with fixed-length column with a total of 500.000 lines. We need to transform those filed into columns separated by a tabulation. Each file have a similar structure. The trick is that each file have a slight different colonne length. so we need to have a programm that first automatically detect the length of each column before doing the split. The program need to do a first pass for this. We tried DataExtract::FixedWidth perl library which use an euristic method but it's not fine. We've put in attachment a sample of few files.
Project ID: 5380186

About the project

22 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average €30 EUR for this job
User Avatar
Hi I am ready to do the task, right now. let me know Thanks
€42 EUR in 1 day
4.9 (47 reviews)
6.4
6.4
User Avatar
Lets Start. Having a team of Excel Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
€25 EUR in 1 day
4.9 (142 reviews)
6.0
6.0
User Avatar
Bonjour, je suis intéressé par votre projet. Si vous voulez, on peut avoir une courte discussion. Je peux coder un macro pour traiter ces fichiers en bloque. Merci
€30 EUR in 3 days
4.8 (31 reviews)
5.6
5.6
User Avatar
I'm interested. sample output below First non empty line will be used to calculate colum length, so some files must be corrected manually (removing some lines, or adding a marker line in case when there is no space between column names 0 0 UNK HERMES PETER THOMAS MARIE 5-29-1786NONE must be changed into * * * * * * * * * 0 0 UNK HERMES PETER THOMAS MARIE 5-29-1786NONE -add a line with stars in first character of the column MO,DA,YEAR,FATHER LAST,FATHER FIRST,MOTHER LAST,MOTHER FIRST,MARRIAGE,CHILD NAME,LOCATION,SPOUSES NAME, 12,10,181, 12,12,1815,BAENTGES,CASPAR,ANDRES,BARBARA,,MARIE CATHERINE,ALDEGUND,, 6,4,1835,BALTES,CAROLUS,BURGER,BARBARA,,BALTES,ALDEGUND,, 8,25,1833,BALTES,CUNO,BURGER,BARBARA,,MATTHIAS,ALDEGUND,, 8,30,1828,BALTES,UNK,UNK,ANNE CATHERINE,,JOANNES BAPT,ALDEGUND,, 1,ADGORRGEL,CHRISTIAN,MELCHER,ANNE ELIZABETH,,MARGARET,ALDEGUND,, 8,23,1829,AMBROSIUS,AUGUST JOSEPH,UNK,AGNES,,JOANES BAPT,ALDEGUND,, 2,10,1835,ANDREAS,JOSEPH,HAUPST,AGNES,,JOANNES,ALDEGUND,, 1,22,1820,ANDRES,ANDREAS,FOELLEN,ANNE MARIE,,CATHERINE,ALDEGUND,, 1,22,1820,ANDRES,ANDREAS,FOELLEN,ANNE MARIE,,MARIE BARBARA,ALDEGUND,, 3,25,1833,ANDRES,FRIEDERICH,PUTZ,MARIE,,JOANNES PETER,ALDEGUND,, 10,23,1822,ANDRES,JOSEPH,UNK,AGATHA,,JOANNES,ALDEGUND,,
€29 EUR in 1 day
4.8 (17 reviews)
5.5
5.5
User Avatar
You don't mention on what platform you want to run this, but that should not be a showstopper. Another info that would be a good-to-know: can you install whatever extra needed/wanted/helpful module might be needed? So or so, it's a rather common task, and I'd be glad to help. Thank you.
€30 EUR in 1 day
5.0 (23 reviews)
5.2
5.2
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
€29 EUR in 0 day
5.0 (33 reviews)
4.8
4.8
User Avatar
A proposal has not yet been provided
€22 EUR in 1 day
5.0 (10 reviews)
4.4
4.4
User Avatar
Dear Sir, I'd like to help you to complete this task successfully. I'm an experienced Software Engineer with solid knowledge of Java development. I have over 10 years of experience in the field and I'm Oracle Java certified with 100% score. I can develop a Java desktop application that reads every file on a folder and looks for the header text to calculate the widths of your files, and covert it to a delimited csv or excel/word/pdf. It's a custom development so I'm out of your current budget. If you have any doubt, don't hesitate to ask me whatever you need to know. Thank you! Greetings, Francisco Fernandez Cabrera Software Engineer
€100 EUR in 2 days
5.0 (1 review)
4.2
4.2
User Avatar
Hello! I can help you with an excel formula (after csv file being opened in excel). Please let me know.
€22 EUR in 1 day
4.9 (23 reviews)
3.4
3.4
User Avatar
Hello, It is a easy task in perl. How many types of files could be there? We can create a configuration file. Where we can configure the file type and fields supported by that file. Suppose you want a new entry in a file that you can configure in the configuration file and our script will work as before. Let me know if it is ok.
€24 EUR in 1 day
5.0 (3 reviews)
3.3
3.3
User Avatar
hi... i can do this. Please let me know to start immediately. i can deliver you on time. please initiate communication discuss further. thanks
€30 EUR in 1 day
5.0 (7 reviews)
3.0
3.0
User Avatar
I have seen the sample and i have an idea why don't we use a program of visual basic with button function that can do your work . I can do this at this rate.
€29 EUR in 1 day
4.5 (7 reviews)
2.6
2.6
User Avatar
Hi I have gone through with the details and zip file provided by you. i have 4.5+ years of experience and Microsoft Certified Programmer . I am ready to do it in low coast as well for future reference. Thanks Shivendra
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have experience with Python, and it can be used to get your work done. I can write script in python which will, for each file, first get the length of the column and then start doing the processing based on the column length. We can discuss it further.
€19 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to propose my services for all kinds of key punching, because I have general experience in data entry and feel that I would be a better option for quality work. Regards
€20 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hello I am really interested in your project and ready to start the work now and can assure 100% satisfaction, please come on private chat to discuss about your project, You also see my portfolio for proof xbrain solution Thanks
€14 EUR in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of FRANCE
PARIS, France
5.0
14
Payment method verified
Member since Jun 26, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.