Combine in single file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Combine in single file
# 1  
Old 10-19-2011
Combine in single file

I have 2 files: phone.txt and mobile.txt
ex. phone.txt
Code:
MOBILENO|DISABLE_DATE
919687877754|9/1/2011|
919687877762|9/1/2011|
919687880573|9/1/2011|
919687882658|9/2/2011|

Ex. mobile.txt
Code:
MOBILENO |TIME
919687880573|2011-09-17 12:23:40|
919687882658|2011-10-10 21:15:33|
919727465270|2011-01-29 17:02:31|
918758503987|2011-10-07 18:44:48|

I need help for combining in 1 file. It will contain MOBILENO|TIME|DISABLE_DATE. If a number is not in one of the files, then leave that column blank and fill only the column from the existing file.

The result will be like below: Can we use join command? or anything that you can advise. thanks
Code:
919687880573|2011-09-17 12:23:40|9/1/2011
919687882658|2011-10-10 21:15:33|9/2/2011

Moderator's Comments:
Mod Comment Please use code tags

Last edited by zaxxon; 10-19-2011 at 06:26 AM.. Reason: code tags, see PM
# 2  
Old 10-19-2011
join

Hi,

Try this one,

Code:
join -t"|" -1 1 -2 1 File2 File1

Cheers,
RangaSmilie
# 3  
Old 10-19-2011
I've used that command but no result. Anything we can combine and append if the number exist. BTW, i have 3millions lines for 1st file and 4 millions lines in 2nd file.
# 4  
Old 10-19-2011
Try this...
Code:
awk -F"|" 'NR>1 && NR==FNR{a[$1]=$2;next}{if($1 in a){print $1"|"$2"|"a[$1]}}' phone.txt mobile.txt > final.txt

--ahamed
This User Gave Thanks to ahamed101 For This Post:
# 5  
Old 10-19-2011
thanks ahamed. i used nawk and works perfectly. Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Combine multi-row cell into a single line

My CSV file looks similar to this example (the K, L, and M are in the same cell as J but each on a new line within that cell): 1, A, B, C, D 2, E, F, G, H 3, I, J N, O, K L M, 4, P, Q, R, S I would like to have it look like this: 1, A,... (6 Replies)
Discussion started by: Kim Ashby
6 Replies

2. UNIX for Dummies Questions & Answers

Combine 2 Outputs with a single Checklist

Checklist 1.1; Contains Solaris 1.2; Contains Patches 1.3; <no output> 1.3.1; <no output> Output1 1.1 Solaris 10 8/07 s10s_u4wos_12b SPARC 1.2 Patch: 127714-03 Obsoletes: Requires: 120011-14 Incompatibles: Packages: SUNWsshcu, SUNWsshdu, SUNWsshu Patch: 128253-01 Obsoletes:... (5 Replies)
Discussion started by: alvinoo
5 Replies

3. Shell Programming and Scripting

Combine multiple lines into single line

Hi All , I have a file with below data # User@Host: xyz @ # Query_time: t1 Lock_time: t2 Rows_sent: n1 Rows_examined: n2 SET timestamp=1396852200; select count(1) from table; # Time: 140406 23:30:01 # User@Host: abc @ # Query_time: t1 Lock_time: t2 Rows_sent: n1 Rows_examined:... (6 Replies)
Discussion started by: rakesh_411
6 Replies

4. Shell Programming and Scripting

Search Pattern and combine into single file

Hi Experts Please help me out with the following thing: 2 files and want the output file: {No for using FOR loop because I got 22 million lines} Tried that "It processes only 8000 records per hour" I need a faster way out !!! FileA: 9051 9052 9053 9054 9055 9056 9057 9058 9059 ... (5 Replies)
Discussion started by: navkanwal
5 Replies

5. Shell Programming and Scripting

Combine Multiple Files into Single One File One after other

I am trying to combine 4 .dat files into one single Output file Inputs are:- file123.dat, file256.dat, file378.dat & file490 Expected Output:- FileName=file1 {text from file1} EOF {blank line} FileName=file2 {text from file2} EOF {blank line} FileName=file3 {text from file3} EOF... (4 Replies)
Discussion started by: lancesunny
4 Replies

6. Shell Programming and Scripting

how to find first files in a directory and combine them as a single file?

i have below list of files in a directory. /root/admin/files/file1.txt /root/admin/files/file2.txt /root/admin/files/file3.txt /root/admin/files/pattern.txt /root/admin/files/server.txt i need combine the above text files in the below sequence, file1.txt, pattern.txt,server.txt =>... (8 Replies)
Discussion started by: vel4ever
8 Replies

7. Shell Programming and Scripting

Combine 2 values into single variable

Hi gurus, I need to manipulate the output of a database query. The output contains 2 fields (asset and serial number) and I'd like to combine them into a single value, seperated by whitespace. the orginal data is in seprate fileds and of the following format: asset serial asset serial etc ... (6 Replies)
Discussion started by: melias
6 Replies

8. Shell Programming and Scripting

Combine multiple lines in single line

This is related to one of my previous post but now with a slight difference: I need the "Updated:" to be in one line as well as the "Information:" on one line as well. These are in multiple lines right now as seen below. These can have 2 or more lines that needs to be in one line. System name:... (8 Replies)
Discussion started by: The One
8 Replies

9. UNIX for Dummies Questions & Answers

Now to merge/combine several filesystems/harddisks to show up as one single?

hi i have a server with 4 harddisks now i want to somehow combine these 4 harddisks to show up to the system as 1 big harddisk, so i can put my web-root into that big virtual partition. can you guys please point me into to the right direction to achieve this? thanks a lot in advance! (2 Replies)
Discussion started by: scarfake
2 Replies
Login or Register to Ask a Question