Terminé

Text Manipulation / Concatenation

I have a CVS text file that can contain up to 9MM rows. Each set of nine rows contains a different variable for the record number that begins each row.

I need a program that will concatenate the 9 variables for each record into one row as a pipe delimited text file.

Here is a sample input file as well as the needed output file:

INPUT FILE

****************************************

#FieldDelimiter:,

survery_result_id,q_type_name,ans_value

187874,exp_days,1

187874,facility,1

187874,actual_days,1

187874,subscription_id,1984366

187874,ship_type,O

187874,rental_id,86286279

187874,rental_date,08-FEB-06

187874,zip,76084

187874,est_arrival_date,09-FEB-06

187877,exp_days,1

187877,facility,2

187877,actual_days,0

187877,subscription_id,791091

187877,ship_type,I

187877,rental_id,82921771

187877,rental_date,09-FEB-06

187877,zip,92646

187877,est_arrival_date,08-FEB-06

****************************************

OUTPUT FILE

****************************************

187874||1|1|1984366|O|86286279|08-FEB-06|76084|09-FEB-06

187877|1|2|0|791091|I|82921771|09-FEB-06|92646|08-FEB-06

****************************************

Please keep in mind that I could have up to 9MM records. I am not sure what progrmaming language would be best to write this in. I am open to suggestions. I just need to be able to run it on my Windows XP machine.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP.

Compétences : PHP

en voir plus : what's my zip coder, u.s. pipe, open text, cvs hire, best server side web language, best server side language, what is open text, Concatenate, text manipulation, number manipulation, open input file php, php open input file, open input file, text row, concatenate php, row text php, cvs server windows, install cvs server windows, windows cvs server, file manipulation program

Concernant l'employeur :
( 2 commentaires ) United States

Nº du projet : #3286057

Décerné à:

e2espvw

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 4 jours
(18 Commentaires)
4.0

46 freelances font une offre moyenne de 40 $ pour ce travail

sergioes

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(247 Commentaires)
7.4
GetReal

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(312 Commentaires)
7.3
pShankar2

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(409 Commentaires)
7.1
pdarko

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(105 Commentaires)
6.5
mahalosoft

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(112 Commentaires)
6.2
sawamu

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(216 Commentaires)
5.9
iasmumbai

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(139 Commentaires)
5.7
dotnetsqlCoder

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(88 Commentaires)
5.5
dimitrievvg

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(49 Commentaires)
5.1
afzaal820

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(29 Commentaires)
5.1
juanjimenezdvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(82 Commentaires)
4.9
bogdansoima

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(80 Commentaires)
4.9
erikhumala

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(94 Commentaires)
4.8
vw265236vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(46 Commentaires)
4.7
Comintern

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(44 Commentaires)
4.4
parchon

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(40 Commentaires)
4.4
enmaniac

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(41 Commentaires)
4.3
simmy

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(20 Commentaires)
4.2
paxdiablo

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(72 Commentaires)
4.4
vladpvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(39 Commentaires)
4.2