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
PHONE(1)						      General Commands Manual							  PHONE(1)

NAME
phone - Phone utility for DECnet SYNOPSIS
phone [options] Options: [-vVh] [-s switchhook char] [initial command] DESCRIPTION
phone is a program that allows the user to communicate interactively with users on VMS systems. Two user interfaces are available: X-Win- dows (GTK+) and terminal (ncurses). If X-Windows is available and compiled into phone then it will be used unless the -n flag is present on the command line. After entering the phone command you will be presented with the phone screen which has windows for the chat and a command-line at the top. If you are not talking to another user then you can enter commands directly, otherwise you will need to precede commands with the 'switch hook' character, which defaults to the percent sign (%). You can also enter a command for phone on the shell command-line. This command will be executed when phone starts up. This makes it conve- nient to enter commands such as: 'phone answer' or 'phone marsha::chrissie' In command mode phone understands several commands: DIAL <node::user> Call a user ANSWER Answer an incoming call REJECT Reject an incoming call EXIT or QUIT Return the the command prompt HOLD Hold all callers UNHOLD Unhold callers HANGUP Hangup the phone DIR <node> Show users logged into <node> FACSIMILE <file> Send <file> HELP Show this help All commands (apart from QUIT and EXIT) can be abbreviated to 3 characters and all (really all this time) commands are case insensitive. OPTIONS
-h -? Displays help for using the command. -V Show the version of phone. -s Set the switch hook character. This is the character used to switch from talking to another user and entering PHONE commands when using the terminal interface.x -n Disables use of the X-windows user interface. Use this to run phone in an xterm. SEE ALSO
phoned(8) DECnet utilities March 26 1999 PHONE(1)
All times are GMT -4. The time now is 02:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy