Re: help for concatenate 2 files
"Daniel" <[email protected]>
| Newsgroups | gmane.editors.sed.user |
|---|---|
| Message-ID | <[email protected]> |
Of course, it doesn't help to repeat post :) Are those tab characters around the semicolons? Or are they spaces? Would you consider getting rid of the white space around the semicolons? Your file would be easier to deal with in the following delimited format. The combination of the ; delimiter with the surrounding space makes it more difficult to process. 8;2013-03-21;N/A 9;2013-03-21;Mineur 10;2013-03-21;Mineur 11;2013-03-21;Mineur 12;2013-03-25;N/A 13;2013-03-25;N/A Daniel --- In [email protected], "MOKRANI Rachid" <rachid.mokrani@...> wrote: > > Hi, > > I don't know how to concatenate two files with row. > > The first file is : > > cat /tmp/file1 > > bug_id ; creation_ts ; bug_severity > 8 ; 2013-03-21 ; N/A > 9 ; 2013-03-21 ; Mineur > 10 ; 2013-03-21 ; Mineur > 11 ; 2013-03-21 ; Mineur > 12 ; 2013-03-25 ; N/A > 13 ; 2013-03-25 ; N/A > > The second file is : > > cat /tmp/file2 > > bug_id ; bug_when ; added > 9 ; 2013-03-21 15:49:44 ; CONFIRME > 10 ; 2013-03-21 15:04:56 ; CONFIRME > 11 ; 2013-03-21 15:56:59 ; CONFIRME > 12 ; 2013-03-25 17:09:09 ; CONFIRME > > > I don't know how to obtain the following result . > > bug_id ; creation_ts ; bug_severity ; bug_when ; added ; > 8 ; 2013-03-21 ; N/A ; ; ; > 9 ; 2013-03-21 ; Mineur ; 2013-03-21 15:49:44 ; CONFIRME ; > 10 ; 2013-03-21 ; Mineur ; 2013-03-21 15:04:56 ; CONFIRME ; > 11 ; 2013-03-21 ; Mineur ; 2013-03-21 15:56:59 ; CONFIRME ; > 12 ; 2013-03-25 ; N/A ; 2013-03-25 17:09:09 ; CONFIRME ; > 13 ; 2013-03-25 ; N/A ; ; ; > > OR the following > > bug_id ; creation_ts ; bug_severity ; bug_when ; added ; > 8 ; 2013-03-21 ; N/A ; TEST ; TEST ; > 9 ; 2013-03-21 ; Mineur ; 2013-03-21 15:49:44 ; CONFIRME ; > 10 ; 2013-03-21 ; Mineur ; 2013-03-21 15:04:56 ; CONFIRME ; > 11 ; 2013-03-21 ; Mineur ; 2013-03-21 15:56:59 ; CONFIRME ; > 12 ; 2013-03-25 ; N/A ; 2013-03-25 17:09:09 ; CONFIRME ; > 13 ; 2013-03-25 ; N/A ; TEST ; TEST ; > > > Any help will be really appreciate. > Best regards. >