Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Combine in single file

Login to Discuss or Reply to this Discussion in Our Community

 
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:
khingx
# 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