Sponsored Content
Full Discussion: Combine in single file
Top Forums Shell Programming and Scripting Combine in single file Post 302565900 by khingx on Wednesday 19th of October 2011 05:16:41 AM
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
 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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

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

7. 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

8. 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

9. 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
GNOME-PHONE-MANAGER(1)						   User Commands					    GNOME-PHONE-MANAGER(1)

NAME
gnome-phone-manager - Manage your mobile phone USAGE
gnome-phone-manager [--identify <baddr>] [--config] [-d|--debug]] [--display=DISPLAY] DESCRIPTION
This manual page documents briefly the gnome-phone-manager command. gnome-phone-manager is a program created to allow you to control aspects of your mobile phone from your GNOME 2 desktop. Current features include: - Runs in the background; indicates status on the panel notification area, - Display on-screen alert when text message (SMS) arrives, - Text message (SMS) sending facility, - Evolution Addressbook integration. OPTIONS
Help Options: -?, --help Show help options --help-all Show all help options --help-gtk Show GTK+ Options --help-gst Show GStreamer Options Application Options: --identify <bdaddr> Show model name of the device with Bluetooth address bdaddr. --config Write the configuration file for gnokii debugging -d, --debug Enable debug --display=DISPLAY X display to use SEE ALSO
Homepage: http://live.gnome.org/PhoneManager AUTHOR
gnome-phone-manager was written by Bastien Nocera <<hadess@hadess.net>> and Edd Dumbill <edd@usefullinc.com> This manual page was written by Francesco Namuri <francesco@namuri.it> for the Debian project (but may be used by others). Francesco Namuri July 2007 GNOME-PHONE-MANAGER(1)
All times are GMT -4. The time now is 04:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy