RE: merging two tabseparated text files.
Title: RE: Terrible at my logic your data does not match with the info... =( -Original Message-From: Mohanty, Debi (MED, TCS) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002 12:46 PMTo: [EMAIL PROTECTED]Subject: merging two tabseparated text files. Hi, Please any one suggest how can I add two tabseparated text files in to one tabseparated text file. In the text file 1 and the text file2 One column is common to both the files. So Is there any way by comparing the record no (which is present in both the files), I will be generate a single file. As per example :- File 1:-- Orig Report #Author PhoneAuthor employee #Author nameCustomer CountryOrig Created By **1026921Y7317KAKIZAWA,TSUYOSHIJAPANKIDOKORO,MIYUKI1026922Y7677TAKAAKI,TOBEJAPANTAKAAKI,TOBE1026923843421EXPOSITO,JEAN-PIERREFRANCEEXPOSITO,JEAN-PIERRE102692414502ROULLEAU DENISFRANCEROULLEAU,DENIS10269259PERRET, DENISFRANCEPERRET, Denis10269269PERRET, DENISFRANCEPERRET, Denis10269273290THOMAS, JULIANUNITED KINGDOMThomas, Julian10269282545MURTON,BOBIRELANDMURTON,BOB File2:- Orig Report #Actions TakenProblem DescriptionInvestigation SummaryValidation of EffectivenessTask notes1026921Kanto U/S, Yokoyama-sanEOLOn EchopacEOL*** NOTES FROM: KIDOKORO,MIYUKI *** 020701EOLSHR-02G-009EOL1026922EOLNeed the evaluation EOLERROR 38 appeared. She checked the cassette correctly mounted and tried theEOL(barak Jul.2,2002) Status to EVAL.EOLEOLEOL1026923We must get theEOLThe systeme can make only fluoro with the We have error 4A6B and the collimator board failed led (Michel Le Morvan, 02 July 2002) Deter*** NOTES FROM: LE_MORVAN,MICHEL *** 020708EOL1026924this type of power supply is no more dc outputs on power supply*** NOTES FROM: KRISTOFFERSEN,JAN *** 0207051026925Je pense qu'il serait preferable de realiser cette operationEOLavant l'arrivee chez le client.Perte de temps durant l'installation (Michel Le Morvan, 02 July 2002) Determined *** NOTES FROM: "DDTs-to-CQA" *** 020702EOL102690this type of power supply is no more dc outputs on power supply*** NOTES FROM: KRISTOFFERSEN,JAN *** 020705192345this type of power supply is no more dc outputs on power supply*** NOTES FROM: KRISTOFFERSEN,JAN *** 020705 Please help me on this issue. ThanksRegards Debi
RE: merging two tabseparated text files.
Title: RE: Terrible at my logic
easy with hashes.
#untested
my %hash1;
my %hash2;
open(FILE1, $file1) || die "Can't open $file1 :
$!\n";
foreach my $line (FILE1)
{
chomp($line);
my @line = split(/ +/,$line);
my $key = $line[0];
$hash1{$key} = join(" ",@line);
}
close(FILE1);
open(FILE2, $file2) || die "Can't open $file2 :
$!\n";
foreach my $line (FILE1)
{
chomp($line);
my @line = split(/ +/,$line);
my $key = $line[0];
$hash2{$key} = join(" ",@line);
}
close(FILE2);
foreach my $key (keys %hash1)
{
print "$key $hash1{$key}
$hash2{$key}\n";
}
-Original Message-From: Mohanty, Debi (MED, TCS)
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002
13:46To:
[EMAIL PROTECTED]Subject: merging two
tabseparated text files.
Hi,
Please any one suggest how can I add two tabseparated text
files in to one tabseparated text file.
In
the text file 1 and the text file2 One column is common to both the files. So
Is there any way by comparing the record no (which is present in both the
files), I will be generate a single file.
As
per example :-
File
1:--
Orig
Report #Author PhoneAuthor employee #Author
nameCustomer CountryOrig Created By
**1026921Y7317KAKIZAWA,TSUYOSHIJAPANKIDOKORO,MIYUKI1026922Y7677TAKAAKI,TOBEJAPANTAKAAKI,TOBE1026923843421EXPOSITO,JEAN-PIERREFRANCEEXPOSITO,JEAN-PIERRE102692414502ROULLEAU
DENISFRANCEROULLEAU,DENIS10269259PERRET,
DENISFRANCEPERRET, Denis10269269PERRET,
DENISFRANCEPERRET, Denis10269273290THOMAS,
JULIANUNITED KINGDOMThomas,
Julian10269282545MURTON,BOBIRELANDMURTON,BOB
File2:-
Orig
Report #Actions TakenProblem DescriptionInvestigation
SummaryValidation of EffectivenessTask
notes1026921Kanto U/S, Yokoyama-sanEOLOn
EchopacEOL*** NOTES FROM: KIDOKORO,MIYUKI ***
020701EOLSHR-02G-009EOL1026922EOLNeed the
evaluation EOLERROR 38 appeared. She checked the cassette
correctly mounted and tried theEOL(barak Jul.2,2002) Status to
EVAL.EOLEOLEOL1026923We must get
theEOLThe systeme can make only fluoro with the We have error
4A6B and the collimator board failed led (Michel Le Morvan, 02
July 2002) Deter*** NOTES FROM: LE_MORVAN,MICHEL ***
020708EOL1026924this type of power supply is no more
dc outputs on power supply*** NOTES FROM: KRISTOFFERSEN,JAN
*** 0207051026925Je pense qu'il serait preferable de realiser cette
operationEOLavant l'arrivee chez le client.Perte de temps durant
l'installation (Michel Le Morvan, 02 July 2002) Determined
*** NOTES FROM: "DDTs-to-CQA" ***
020702EOL102690this type of power supply is no more dc
outputs on power supply*** NOTES FROM: KRISTOFFERSEN,JAN ***
020705192345this type of power supply is no more dc outputs on
power supply*** NOTES FROM: KRISTOFFERSEN,JAN ***
020705
Please help me on this issue.
ThanksRegards
Debi
RE: merging two tabseparated text files.
Title: RE: Terrible at my logic file 3 is a manual merge file. attached below is the file 2 and file 3. if we take a small example then . All the files are tabseparated text files. file1 col1 col2 col3 col4 1text1text2 2text4text5 3text6text7 File2 col1col6col7col8 1text11text12 2text13text14text16 4text18 text18 Then the final file will be col1 col2 col3 col4 col6 col7 col8 1 text1 text2text11text12 2text4text5text13text14text16 3 test6 text7 4text18text18 Please help me on this issue... ThanksRegards Debi -Original Message-From: Krishna, Hari [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002 1:30 PMTo: Mohanty, Debi (MED, TCS)Subject: RE: merging two tabseparated text files. I don't get it. File 1 is clear. Could get file 2 too. But Not sure why the file 3 looks different if its manual merge or samplle file?? Can you send the output file?? -Original Message-From: Mohanty, Debi (MED, TCS) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002 01:46 PMTo: [EMAIL PROTECTED]Subject: merging two tabseparated text files. Hi, Please any one suggest how can I add two tabseparated text files in to one tabseparated text file. In the text file 1 and the text file2 One column is common to both the files. So Is there any way by comparing the record no (which is present in both the files), I will be generate a single file. As per example :- File 1:-- Orig Report #Author PhoneAuthor employee #Author nameCustomer CountryOrig Created By **1026921Y7317KAKIZAWA,TSUYOSHIJAPANKIDOKORO,MIYUKI1026922Y7677TAKAAKI,TOBEJAPANTAKAAKI,TOBE1026923843421EXPOSITO,JEAN-PIERREFRANCEEXPOSITO,JEAN-PIERRE102692414502ROULLEAU DENISFRANCEROULLEAU,DENIS10269259PERRET, DENISFRANCEPERRET, Denis10269269PERRET, DENISFRANCEPERRET, Denis10269273290THOMAS, JULIANUNITED KINGDOMThomas, Julian10269282545MURTON,BOBIRELANDMURTON,BOB File2:- Orig Report #Actions TakenProblem DescriptionInvestigation SummaryValidation of EffectivenessTask notes1026921Kanto U/S, Yokoyama-sanEOLOn EchopacEOL*** NOTES FROM: KIDOKORO,MIYUKI *** 020701EOLSHR-02G-009EOL1026922EOLNeed the evaluation EOLERROR 38 appeared. She checked the cassette correctly mounted and tried theEOL(barak Jul.2,2002) Status to EVAL.EOLEOLEOL1026923We must get theEOLThe systeme can make only fluoro with the We have error 4A6B and the collimator board failed led (Michel Le Morvan, 02 July 2002) Deter*** NOTES FROM: LE_MORVAN,MICHEL *** 020708EOL1026924this type of power supply is no more dc outputs on power supply*** NOTES FROM: KRISTOFFERSEN,JAN *** 0207051026925Je pense qu'il serait preferable de realiser cette operationEOLavant l'arrivee chez le client.Perte de temps durant l'installation (Michel Le Morvan, 02 July 2002) Determined *** NOTES FROM: "DDTs-to-CQA" *** 020702EOL102690this type of power supply is no more dc outputs on power supply*** NOTES FROM: KRISTOFFERSEN,JAN *** 020705192345this type of power supply is no more dc outputs on power supply*** NOTES FROM: KRISTOFFERSEN,JAN *** 020705 Please help me on this issue. ThanksRegards Debi Orig Report # Author PhoneAuthor employee # Author name Customer CountryOrig Created By ** 1026921 Y7317 KAKIZAWA,TSUYOSHI JAPAN KIDOKORO,MIYUKI 1026922 Y7677 TAKAAKI,TOBEJAPAN TAKAAKI,TOBE 1026923 843421 EXPOSITO,JEAN-PIERREFRANCE EXPOSITO,JEAN-PIERRE 1026924 14502 ROULLEAU DENISFRANCE ROULLEAU,DENIS 1026925 9 PERRET, DENIS FRANCE PERRET, Denis 1026926 9 PERRET, DENIS FRANCE PERRET, Denis 1026927 3290THOMAS, JULIAN UNITED KINGDOM Thomas, Julian 1026928 2545MURTON,BOB IRELAND MURTON,BOB Orig Report # Actions Taken Problem Description Investigation Summary Validation of Effectiveness Task notes 1026921 Kanto U/S, Yokoyama-sanEOLOn EchopacEOL *** NOTES FROM: KIDOKORO,MIYUKI *** 020701EOLSHR-02G-009EOL 1026922 EOLNeed the evaluationEOLERROR 38 appeared. She checked the cassette correctly mounted and tried theEOL (barak Jul.2,2002) Status to EVAL. EOLEOLEOL 1026923 We must get theEOLThe systeme can make only fluoro with the We have error 4A6B and the collimator board failed led (Michel Le Morvan, 02 July 2002) Deter *** NOTES FROM: LE_MORVAN,MICHEL *** 020708EOL 1026924 this type of power supply isno more dc outputs on power supply *** NOTES FROM: KRISTOFFERSEN,JAN *** 020705 1026925 Je pense qu'il serait preferable de realiser cette operationEOLavant l'arrivee chez le client.
