04-20-2011
using diff to on two file but ignoring the last comma separate value
Hi guys
I have two file which I sdiff.
ie
file 1: AA,12,34,56,,789,101,,6666
file 2: AA,12,34,56,,789,101,,7777
The last comma separated value will always change from one day to the next.
Is there another unix utility I can use that will sdiff two files but ignore the last comma separate value? I need the sdiff output if another other comma separate value changes.
any advise is appreciated.
Last edited by wny201; 04-20-2011 at 09:59 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I want to compare two files. All records in file 2 that are not in file 1 should be output to file 3.
For example:
file 1
123
1234
123456
file 2
123
2345
23456
file 3 should have
2345
23456
I have looked at diff, bdiff, cmp, comm, diff3 without any luck! (2 Replies)
Discussion started by: blt123
2 Replies
2. Shell Programming and Scripting
hi experts,
i have some problem with count data which separate by comma, below sample data :
01,011222823b6d,011222823f29,0028a5,002993,6212345678,
659111111111,6598204507,6281105008,6596197849,_,525016160836958,_,
ffffffff,000000000000000000000000,_,_,_,fd,fd,ff,00,1,0028a5-002993,_,... (10 Replies)
Discussion started by: bucci
10 Replies
3. UNIX for Dummies Questions & Answers
so i have a simple file called -x and i need it renamed to x
now i dont understand why when using the most basic methods, only the code mv ./-x x changes the file name while using any other type of escape characters around the dash, such as single/double quotations or backslash, doesnt.
... (5 Replies)
Discussion started by: LumpSum
5 Replies
4. Shell Programming and Scripting
Hi all,
I would lke to compare two pipe delimited files but I already expect one field to be different and would like to disregard this field. So for the example below I would like to disregard field three and show line 1 as no difference but line 2 as a difference.
Any ideas?
File 1
... (4 Replies)
Discussion started by: pxy2d1
4 Replies
5. Shell Programming and Scripting
HI,
command to cat a readable file by ignoring the first line and last line
or command to cat a readable file by ignoring the lines with delimiter
Please advise on this. (2 Replies)
Discussion started by: thelakbe
2 Replies
6. UNIX for Dummies Questions & Answers
Hi everyone, I have 2 very large files (each file have about 600k lines) and I want to see which numbers in file1 are not in file2, I thought of doing a diff, however diff will also display the changes, instead of just adds and delete, this makes it very hard to sort out just the adds and deletes.... (1 Reply)
Discussion started by: robertrobert905
1 Replies
7. Shell Programming and Scripting
Hi all
This time my input conatin 3 columns:
ERCC1 (PA155) Platinum compounds (PA164713176) Allele A is not associated with response to Platinum compounds in women with Ovarian Neoplasms as compared to allele C .
CES1 (PA107) methylphenidate (PA450464) Genotype CT is not... (4 Replies)
Discussion started by: Priyanka Chopra
4 Replies
8. Shell Programming and Scripting
Hi All
I need help to separate entries after commas in my
I have 2 columns in my file like this
Ramush, Shyam, Mohan First
Ram, Mohan, Kaavya Second, Fourth
Kavi, Ram, Shaym, Mohan Third
I ahve to separate entries after comma in a separate row... (9 Replies)
Discussion started by: kareena
9 Replies
9. UNIX for Advanced & Expert Users
In awk the field seprator is not working properly, I am trying to cut the fields from the file based on the delimiter example comma (,)
awk -F, "{print {$1 FS $3 FS $5 FS FS $2}}" Sample.csv
But i am not getting desired output can anyone help me how to check real ascii comma there in my... (9 Replies)
Discussion started by: rspwilliam
9 Replies
10. Shell Programming and Scripting
I have two files:
smw:/working/iso_testing # cat a
QConvergeConsoleCLI-1.1.03-49.x86_64.rpm
aaa_base-13.2+git20140911.61c1681-1.3.i586.rpm
acpica-20140724-2.1.2.i586.rpm
test.rpm
smw:/working/iso_testing # cat b
QConvergeConsoleCLI-1.1.03-49.x86_64.rpm... (12 Replies)
Discussion started by: jedlund21
12 Replies
SDIFF(1) User Commands SDIFF(1)
NAME
sdiff - side-by-side merge of file differences
SYNOPSIS
sdiff [OPTION]... FILE1 FILE2
DESCRIPTION
Side-by-side merge of differences between FILE1 and FILE2.
Mandatory arguments to long options are mandatory for short options too.
-o, --output=FILE
operate interactively, sending output to FILE
-i, --ignore-case
consider upper- and lower-case to be the same
-E, --ignore-tab-expansion
ignore changes due to tab expansion
-Z, --ignore-trailing-space
ignore white space at line end
-b, --ignore-space-change
ignore changes in the amount of white space
-W, --ignore-all-space
ignore all white space
-B, --ignore-blank-lines
ignore changes whose lines are all blank
-I, --ignore-matching-lines=RE
ignore changes all whose lines match RE
--strip-trailing-cr
strip trailing carriage return on input
-a, --text
treat all files as text
-w, --width=NUM
output at most NUM (default 130) print columns
-l, --left-column
output only the left column of common lines
-s, --suppress-common-lines
do not output common lines
-t, --expand-tabs
expand tabs to spaces in output
--tabsize=NUM
tab stops at every NUM (default 8) print columns
-d, --minimal
try hard to find a smaller set of changes
-H, --speed-large-files
assume large files, many scattered small changes
--diff-program=PROGRAM
use PROGRAM to compare files
--help display this help and exit
-v, --version
output version information and exit
If a FILE is '-', read standard input. Exit status is 0 if inputs are the same, 1 if different, 2 if trouble.
AUTHOR
Written by Thomas Lord.
REPORTING BUGS
Report bugs to: bug-diffutils@gnu.org
GNU diffutils home page: <http://www.gnu.org/software/diffutils/>
General help using GNU software: <http://www.gnu.org/gethelp/>
COPYRIGHT
Copyright (C) 2017 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
cmp(1), diff(1), diff3(1)
The full documentation for sdiff is maintained as a Texinfo manual. If the info and sdiff programs are properly installed at your site,
the command
info sdiff
should give you access to the complete manual.
diffutils 3.6 May 2017 SDIFF(1)