awk compare specific columns from 2 files, print new file
Hello. I have two files. FILE1 was extracted from FILE2 and modified thanks to help from this post. Now I need to replace the extracted, modified lines into the original file (FILE2) to produce the FILE3.
FILE1
FILE2
FILE3 ---------- Post updated at 11:11 PM ---------- Previous update was at 10:46 PM ----------
I was able to do this by first extracting the lines from FILE2 that are in FILE1 > tmp using the post linked to above. Then I used to diff to get the remaining lines from FILE2 > tmp2. I edited tmp2 to remove extraneous symbols and used cat to combine tmp2 and FILE1. sort -n was the final command needed.
Hi guys,
I need some help to come out with a solution . I have seven such files but I am showing only three for convenience.
filea
a5 20
a8 16
fileb
a3 42
a7 14
filec
a5 23
a3 07
The output file shoud contain the data in table form showing first field of... (7 Replies)
Hello,
I am strugling from quite a some time to compare flat files with over 1 million records could anyone please help me.
I want to compare two pipe delimited flat files, file1 with file2 and output the unmatched rows from file2 in file3
Sample File1:
... (9 Replies)
Hi,
My requirement is that I need to compare two files.
For example :
The first file will be having 15 columns and the second file will be having just 10 columns.
Example :
File1 :
abcd,abrd,fun,D000,$15,$236,$217,$200,$200,$200... (3 Replies)
awk experts,
I have a big file of 4000 columns with header. Would like to print the columns with string value of "Commands" in header. File has "," separator. This file is on ESX host with Bash.
Thanks,
Arv (21 Replies)
File 1 has 16 columns so does File 2
I want to remove all records from File 2 that column 1 and column 16 match between file 1 and file 2
delimter of files is ~ (10 Replies)
Hi,
I have multiple files that each contain one column of strings:
File1:
123abc
456def
789ghi
File2:
123abc
456def
891jkl
File3:
234mno
123abc
456def
In total I have 25 of these type of file. (5 Replies)
Hi,
I want to compare two columns from file1 with another two column of file2 and print matched and unmatched column like this
File1
1 rs1 abc
3 rs4 xyz
1 rs3 stu
File2
1 kkk rs1 AA 10
1 aaa rs2 DD 20
1 ccc ... (2 Replies)
Discussion started by: justinjj
2 Replies
LEARN ABOUT DEBIAN
slack-diff
DIFF(1) User Commands DIFF(1)NAME
slack-diff - compare file contents, modes, etc
SYNOPSIS
slack-diff [OPTION]... FILE1 FILE2
DESCRIPTION
A wrapper for diff that displays file modes and other metadata changes.
-u-U NUM --unified[=NUM]
Tell diff(1) to use unified output format.
--diff PROG
Use this program for diffing, instead of diff.
--fakediff
Make a fake diff for file modes and other things that are not file contents. Default is on, can be disabled with --nofakediff.
-r--recursive
Recursively compare any subdirectories found.
-N--new-file
Treat missing files as empty. Default is on, can be disabled with --nonew-file.
--unidirectional-new-file
Treat only missing files in the first directory as empty.
--from-file
Treat arguments as a list of files from which to read filenames to compare, two lines at a time.
-0--null
Use NULLs instead of newlines as the separator in --from-file mode.
--devnullhack
You have a version of diff that can't deal with -N when not in recursive mode, so we need to feed it /dev/null instead of the miss-
ing file. Default is on, can be disabled with --nodevnullhack.
--version
Output version info.
--help Output this help.
FILES are `FILE1 FILE2' or `DIR1 DIR2' or `DIR FILE...' or `FILE... DIR'. If --from-file or --to-file is given, there are no restrictions
on FILES. If a FILE is `-', read standard input.
SEE ALSO diff(1)diffutils 2.8.1 April 2002 DIFF(1)