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
1    text1    text2
2    text4                text5
3    text6                text7
 
File2 
 
col1    col6    col7    col8
1    text11    text12
2    text13    text14    text16
4    text18                 text18       
 
Then the final file will be
 
col1    col2    col3    col4     col6    col7    col8
1        text1    text2            text11   text12
2        text4            text5    text13   text14 text16
3        test6            text7
4                                       text18            text18 
 
Please help me on this issue.......
 
Thanks&Regards
Debi
  
 
 
-----Original Message-----
From: Krishna, Hari [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 29, 2002 1:30 PM
To: 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 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
 
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
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
Orig Report #   Author Phone    Author employee #       Author name     Customer 
Country        Orig Created By **      Status  Customer Address        *ADDR2  *ADDR3  
Actions Taken   Problem Description     Investigation Summary   Validation of 
Effectiveness     Task notes
1026921         Y7317   KAKIZAWA,TSUYOSHI       JAPAN   KIDOKORO,MIYUKI EVAL    
.<EOL>MOOKA-SHI, TOCHIGI-KEN<EOL><EOL><EOL>     MOOKA-SHI, TOCHIGI-KEN                 
 Kanto U/S, Yokoyama-san<EOL>On Echopac<EOL>                     *** NOTES FROM: 
KIDOKORO,MIYUKI *** 020701<EOL>SHR-02G-009<EOL>
1026922         Y7677   TAKAAKI,TOBE    JAPAN   TAKAAKI,TOBE    EVAL    SCHOOL, KAGAWA 
PREFECTURE,<EOL>JAPAN<EOL><EOL><EOL>     JAPAN           <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         843421  EXPOSITO,JEAN-PIERRE    FRANCE  EXPOSITO,JEAN-PIERRE    ASGN   
 13000 MARSEILLE<EOL><EOL><EOL><EOL>                     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         100004502       ROULLEAU   DENIS        FRANCE  ROULLEAU,DENIS  EVAL   
 8 RUE DES PRES SAINT-MARTIN<EOL>PONTAULT COMBAULT<EOL>77340<EOL><EOL>   PONTAULT 
COMBAULT       77340   this type of power supply is    no more dc outputs on power 
supply                      *** NOTES FROM: KRISTOFFERSEN,JAN *** 020705
1026925         99999   PERRET, DENIS   FRANCE  PERRET, Denis   ASGN    AV 
M.DEBRE<EOL>?<EOL><EOL><EOL>NIMES             XX999999       ?               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>
1026926         99999   PERRET, DENIS   FRANCE  PERRET, Denis   ASGN    AV 
DEBRE<EOL>*<EOL><EOL><EOL>NIMES             XX999999 *                                 
              
1026927         3290    THOMAS, JULIAN  UNITED KINGDOM  Thomas, Julian  SCHD    
UMEA<EOL><EOL><EOL><EOL>UMEA              XX999999                                     
                 
1026928         2545    MURTON,BOB      IRELAND MURTON,BOB      EVAL    MERCY 
HOSPITAL<EOL>CORK<EOL>IRELAND<EOL><EOL>   CORK    IRELAND                              
   
1026929         Y7317   KAKIZAWA,TSUYOSHI       JAPAN   KIDOKORO,MIYUKI ASGN    
.<EOL>SAPPORO-SHI, HOKKAIDO<EOL><EOL><EOL>      SAPPORO-SHI, HOKKAIDO                  
                         
1026932         2593    BRENKUS, MICHAEL        UNITED STATES OF AMERICA        
brenkus, michael        ASGN    THE OHIO STATE UNIVERSITY/UHC<EOL>410 W 10TH 
AVENUE<EOL><EOL><EOL>COLUMBUS          OH43210-1243        410 W 10TH AVENUE           
                                    
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


Reply via email to