RE: merging two tabseparated text files.

[FARRINGTON, RYAN]

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 PM To: [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 Phone Author employee # Author name Customer Country Orig Created By ** 1026921  Y7317 KAKIZAWA,TSUYOSHI JAPAN KIDOKORO,MIYUKI 1026922  Y7677 TAKAAKI,TOBE JAPAN TAKAAKI,TOBE 1026923  843421 EXPOSITO,JEAN-PIERRE FRANCE EXPOSITO,JEAN-PIERRE 1026924  100004502 ROULLEAU   DENIS FRANCE ROULLEAU,DENIS 1026925  99999 PERRET, DENIS FRANCE PERRET, Denis 1026926  99999 PERRET, DENIS FRANCE PERRET, Denis 1026927  3290 THOMAS, JULIAN UNITED KINGDOM Thomas, Julian 1026928  2545 MURTON,BOB IRELAND MURTON,BOB   File2:-----   Orig Report # Actions Taken Problem Description Investigation Summary Validation of Effectiveness Task notes 1026921  Kanto U/S, Yokoyama-san<EOL>On Echopac<EOL>   *** NOTES FROM: KIDOKORO,MIYUKI *** 020701<EOL>SHR-02G-009<EOL> 1026922 <EOL>Need the evaluation  <EOL>ERROR 38 appeared. She checked the cassette correctly mounted and tried the<EOL> (barak Jul.2,2002) Status to EVAL.  <EOL><EOL><EOL> 1026923 We must get the<EOL>The 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 *** 020708<EOL> 1026924 this type of power supply is  no more dc outputs on power supply   *** NOTES FROM: KRISTOFFERSEN,JAN *** 020705 1026925 Je pense qu'il serait preferable de realiser cette operation<EOL>avant l'arrivee chez le client. Perte de temps durant l'installation  (Michel Le Morvan,  02 July 2002) Determined   *** NOTES FROM: "DDTs-to-CQA" *** 020702<EOL> 102690 this type of power supply is  no more dc outputs on power supply   *** NOTES FROM: KRISTOFFERSEN,JAN *** 020705 192345 this type of power supply is  no more dc outputs on power supply   *** NOTES FROM: KRISTOFFERSEN,JAN *** 020705 Please help me on this issue.   Thanks&Regards Debi