Project Detail

perl script to create de-normalized output file

perl script to create de-normalized output file is project number 151696
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: dims

Budget: $30-100

Created: 06/12/2007 at 11:04 EDT

Bid Count: 11

Average Bid:
$ 36

06/17/2007 at 11:04 EDT

Project Creator: sanjushah offline
Employer Rating: 9.8571/10 (7 reviews)

Description

I have a pipe delimited flat file which has 1 record per invoice-number. Per invoice records, there's header section, lines section (repeated multiple times - could go as much as 100 times) and the trailer section - something like this:

HA1|HA2|HA3|L1-1|L1-2|L1-3|L1-4|L2-1|L2-2|L2-3|L2-4|T1|T2|T3
HB1|HB2|HB3|L1-1|L1-2|L1-3|L1-4|L2-1|L2-2|L2-3|L2-4|T1|T2|T3

The output file should like this:
HA1|HA2|HA3|L1-1|T1|T2|T3
HA1|HA2|HA3|L1-2|T1|T2|T3
HA1|HA2|HA3|L1-3|T1|T2|T3
HA1|HA2|HA3|L1-4|T1|T2|T3
HA1|HA2|HA3|L2-1|T1|T2|T3
HA1|HA2|HA3|L2-2|T1|T2|T3
HA1|HA2|HA3|L2-3|T1|T2|T3
HA1|HA2|HA3|L2-4|T1|T2|T3
HB1|HB2|HB3|L1-1|T1|T2|T3
HB1|HB2|HB3|L1-2|T1|T2|T3
HB1|HB2|HB3|L1-3|T1|T2|T3
HB1|HB2|HB3|L1-4|T1|T2|T3
HB1|HB2|HB3|L2-1|T1|T2|T3
HB1|HB2|HB3|L2-2|T1|T2|T3
HB1|HB2|HB3|L2-3|T1|T2|T3
HB1|HB2|HA3|L2-4|T1|T2|T3

For someone with Perl Expertise - this should be pretty st forward script.

The script should be well documented and maintainable and needs to run on Linux. Your work should be guaranteed to work as per requirements :)

Report Violation

Job Type

Perl

See more: create, file, flat file, header, invoice, perl, record, requirements, script, trailer, work

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

1 day

06-12-2007 11:37 EDT

9.9264/10
(326 reviews)

I can write this Perl script today. Escrow deposit is required, please.

dims offline

1 day

06-12-2007 23:10 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(28 reviews)

Can show demo for you

nuscpe offline

1 day

06-12-2007 19:33 EDT

9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10 9.7/10
(20 reviews)

I am good at perl. I can do it for you today. Escrow deposit is required. Thanks.

FocusService offline

1 day

06-12-2007 18:17 EDT

9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10
(2 reviews)

I am a experienced perl programmer. I can do it quickly.Pls check PM.Thanks!

Diamantis offline

1 day

06-12-2007 13:51 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

I am a Perl programmer and can easily do such data transformations

idiotkid offline

1 day

06-12-2007 13:58 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

sanju, what I get from your posting that you want to remove header and trailer from output and convert every other record line of input text file to couple of linea in the output text file. If this is so, a solution that will run on Linux can be cooked up in around an hour (or lesser) assuming it's straightforward to identify the header and trailer records in input text file. The solution can be easily implemented using either of bash/awk/perl scripting.

gkfabs offline

2 days

06-12-2007 11:20 EDT

(No Feedback Yet)

Hi I have experience with linux environment and perl script.

AncaU offline

2 days

06-12-2007 13:03 EDT

(No Feedback Yet)

Hi! Please read PM

katsarov offline

1 day

06-12-2007 13:40 EDT

(No Feedback Yet)

I have a similar script done. I will need less than a day to modify it.

monemran offline

1 day

06-12-2007 17:01 EDT

(No Feedback Yet)

i can do it.

jjchan2023 offline

1 day

06-12-2007 22:15 EDT

(No Feedback Yet)

sir i can write a script for you

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.