07-22-2009
It's because you change your input. Use ur old file with "unnecessary fields" and u'll probably get the desire output ^_^
10 More Discussions You Might Find Interesting
1. Solaris
I need to get a few details from the command line. I need to get the kilobytes per second that my server is transfering to another or has available and I need to test the connection to make sure that its a sound connection. I also need to keep track of the response time.
I have been playing... (1 Reply)
Discussion started by: nowayin
1 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
Can anyone please help me in unix command
Query:
====
File contains data along with date and time stamp like,
..
Date: 08:23:2005 01:00:00
method: xyz
init variables
Date 08:23:2005 01:00:01
method: xyz
finished init variable
.... (2 Replies)
Discussion started by: thaduka
2 Replies
3. UNIX for Advanced & Expert Users
Hi,
In a file I have data like...
-rw-r----- 1 ftpuser users 1036695 Jul 6 14:59 ./APRIL 2007/Ujjain/My Disc (D)/9565DW07.04B
-rw-r----- 1 ftpuser users 124080 Jul 6 14:59 ./APRIL 2007/Vadodara/vad_APRIL07/2082DW07.04B
The above data is extracted using "find . -name... (12 Replies)
Discussion started by: ronald_brayan
12 Replies
4. Shell Programming and Scripting
What are some ways to tell if a given file is presently being used
by a process? How can you tell what sort of access the process has
to the file (read from, written to, filehandle held open, etc)?
Can more than one process access the file at the same time? (2 Replies)
Discussion started by: choco4202002
2 Replies
5. Shell Programming and Scripting
My data is something like as shown below. Out of this i want the details of alarms (ex: 1947147711,1947147081......) and the fields( ex :sw=tacmwafabb9:shelf=1:slot=5-2:pport=2)
Once i have these details separated, i want the count of these excluding the duplicates. What is the best possible way... (7 Replies)
Discussion started by: rdhanek
7 Replies
6. Shell Programming and Scripting
I have a file 123.txt which is
aasaasas=1
bsasasasasa=2
sawqas=3
I want my output to be
1
2
3
I am new to scripting can some1 help me out. (14 Replies)
Discussion started by: karthikkasarla
14 Replies
7. Shell Programming and Scripting
Hi All,
I am writing the following Perl Scrip and need your help in Pattern matching :
I have the following Shell Script that would read line by line from the file (file_svn) and would inturn calls the Perl Script:
#!/bin/bash
perl_path="/home/dev/filter"... (2 Replies)
Discussion started by: filter
2 Replies
8. Shell Programming and Scripting
I have the below contents in a file after making the below curl call
curl ... | grep -E "state|Rno" | paste -sd',\n' | grep "Disconnected" > test
"state" : "Disconnected",, "Rno" : "5554f1d2"
"state" : "Disconnected",, "Rno" : "10587563"
"state" : "Disconnected",, "Rno" :... (2 Replies)
Discussion started by: Vaibhav H
2 Replies
9. Shell Programming and Scripting
I have 40000 records in a file where i need to change the 7th field date format from 05142016 to 20160514
I have given field below. any help would be highly appreciated.
364512|9999999|9999999|210553|195495477|195257095|05142016|10009|36313
---------- Post updated at 05:02 AM... (2 Replies)
Discussion started by: arun888
2 Replies
10. UNIX for Beginners Questions & Answers
I have requirement to search for a text in the file and retrieve required lines that is user defined with unix command.
Eg:
Find the text UNIX in the below file and need to return Test 8 & Test 9
Test 1
Test 2
Test 3
Test 4
UNIX
Test 5
Test 6
Test 7
Test 8
Test 9
Result can... (8 Replies)
Discussion started by: Arunkumarsak4
8 Replies
JOIN(1) FSF JOIN(1)
NAME
join - join lines of two files on a common field
SYNOPSIS
join [OPTION]... FILE1 FILE2
DESCRIPTION
For each pair of input lines with identical join fields, write a line to standard output. The default join field is the first, delimited
by whitespace. When FILE1 or FILE2 (not both) is -, read standard input.
-a SIDE
print unpairable lines coming from file SIDE
-e EMPTY
replace missing input fields with EMPTY
-i, --ignore-case ignore differences in case when comparing fields
-j FIELD
(obsolescent) equivalent to `-1 FIELD -2 FIELD'
-j1 FIELD
(obsolescent) equivalent to `-1 FIELD'
-j2 FIELD
(obsolescent) equivalent to `-2 FIELD'
-o FORMAT
obey FORMAT while constructing output line
-t CHAR
use CHAR as input and output field separator
-v SIDE
like -a SIDE, but suppress joined output lines
-1 FIELD
join on this FIELD of file 1
-2 FIELD
join on this FIELD of file 2
--help display this help and exit
--version
output version information and exit
Unless -t CHAR is given, leading blanks separate fields and are ignored, else fields are separated by CHAR. Any FIELD is a field number
counted from 1. FORMAT is one or more comma or blank separated specifications, each being `SIDE.FIELD' or `0'. Default FORMAT outputs the
join field, the remaining fields from FILE1, the remaining fields from FILE2, all separated by CHAR.
AUTHOR
Written by Mike Haertel.
REPORTING BUGS
Report bugs to <bug-coreutils@gnu.org>.
COPYRIGHT
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
LAR PURPOSE.
SEE ALSO
The full documentation for join is maintained as a Texinfo manual. If the info and join programs are properly installed at your site, the
command
info join
should give you access to the complete manual.
join (coreutils) 4.5.3 February 2003 JOIN(1)