02-13-2017
This User Gave Thanks to Don Cragun For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to extract the uncommon (better say incremental) part from 2 files say file_1 and file_2.
file_2 contains everything that is in file_1. That is file_2 has been created internally somehow :
cat file_1 temp_file > file_2
My objective is to extract the temp_file part from... (2 Replies)
Discussion started by: sabyasm
2 Replies
2. Post Here to Contact Site Administrators and Moderators
Hi,
I need to extract the uncommon numbers from file1 and file2
For Example:
File1
1
2
3
4
5
File2
1
2
3
4
5
6 (2 Replies)
Discussion started by: salaathi
2 Replies
3. Shell Programming and Scripting
I've got two large csv text table files with different number of columns each.
I have to compare them based on first two columns and create resulting file
that would in case of matched first two columns include all values from first one and all values (except first two colums) from second one. I... (5 Replies)
Discussion started by: agb2008
5 Replies
4. Shell Programming and Scripting
A file contains the following information shown below. Every ceName has 2 consecutive lines that have to be evaluated, using awk, sed, cut (any common unix tools).
Input file:
ceName: Node-1
processName: tzMgmt
Status: PROCESS_NOT_RUNNING
ceName: Node-2
processName: tzMgmt
Status:... (15 Replies)
Discussion started by: BRH
15 Replies
5. Shell Programming and Scripting
Hi,
I have two text files. Need to create a third text file extracting specific data from first two existing files..
Text File 1: Format contains:
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Aug 4 21:06:34 2010
some text ............so on...and somwhere text like:
Record 1:... (1 Reply)
Discussion started by: shashi143ibm
1 Replies
6. UNIX for Dummies Questions & Answers
I have two files, file1.txt and file2.txt
I want to find UNcommon between two files
with
while read line
do
grep -v $line file2.txt
done<file1.txt
I get the reverse grep for every line it reads (7 Replies)
Discussion started by: FelipeAd
7 Replies
7. Shell Programming and Scripting
I want to compare 2 files and create third file with uncommon content.
e.g.
file1
ajay suhas tom nisha vijay mahish
file2
ajay suhas tom nisha
expected output file content
vijay mahish
Is it possible in single command ?
Thanks,
Ajay (6 Replies)
Discussion started by: ajaypatil_am
6 Replies
8. Shell Programming and Scripting
Hello,
I have 2 files.
File A and File B
File A has below data
2000328288038 02 <-- its 02
2000292181441 11
2000292181441 11
2000000073963 25
2000075097222 22
File B has below data
2000328288038,2,1234 <-- 2 (it should also be taken care)
2000292181441,11,1233... (2 Replies)
Discussion started by: mirwasim
2 Replies
9. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
10. UNIX for Beginners Questions & Answers
I have looked through several threads regarding merging files with awk and attempted using join however have been unsuccessful likely as I do not fully understand awk.
What I am attempting is to take a csv file which could be between 1 and 15,000 lines with 5 colums and another csv file that will... (4 Replies)
Discussion started by: cdubu2
4 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specifed in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
JOIN(1)