There are several ways to do this, but this follows the example you gave. You have to use the file with the fewer lines to grep the file with more. This isn't 100% accurate though. Suppose you have 6 in file2 and not in file1, then it would not be printed. You can create two loops and reverse the files on the second one to catch this.
Code:
for num in `cat File2.csv`
do
strng=${strng:-"($num"}${strng:+"|$num"}
done
strng=${strng}${strng:+")"} # creates '(2|3|5)'
egrep -v $strng File1.csv
You could also do this with a simple diff, but then you have to format the output properly.
Hi
I have a file having 1000 rows. Now I would like to remove 10 rows from it. Plz give me the script.
Eg:
input file like
4 1 4500.0 1
5 1 1.0 30
6 1 1.0 4500
7 1 4.0 730
7 2 500000.0 730
8 1 785460.0 45
8 7 94255.0 30
9 1 31800.0 30
9 4 36000.0 30
10 1 15000.0 30... (5 Replies)
Hello,
I am supposed to process about 100 csv files. But these files have some extra lines at the bottom of the file. these extra lines start with a header for each column and then some values below. These lines are actually a summary of the actual data and not supposed to be processed. These... (8 Replies)
I need to delete rows based on the number of lines in a different file, I have a piece of code with me working but when I merge with my C application, it doesnt work.
sed '1,'\"`wc -l < /tmp/fileyyyy`\"'d' /tmp/fileA > /tmp/filexxxx
Can anyone give me an alternate solution for the above (2 Replies)
I have CSV file that contains data in the format as shown below:
ABC, 67, 56, 67, 78, 89, 76, 55
PDR, 85, 83, 83, 72, 82, 89, 83
MPG, 86, 53, 54, 65, 23, 54, 75
..
..
..
..
I want to create a script that will pull out the rows from the above sheet and paste it into another CSV file.... (12 Replies)
Hi,
I need help to remove blank rows at the end of file.
Sample data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga Kino SF",Tønsberg,202-1,Tønsberg SF 4,202-1-4
,,,,
,,,,
,,,,
,,,,
Expected data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga... (6 Replies)
Hello list,
I am working on a csv file which contains two fields per record which contain IP addresses. What I am trying to do is find records which have identical fields(IP addresses) which occur 4(four) times, and if they do, delete all records with that specific identical field(ip address).
... (4 Replies)
Hi All,
I have many of files(.csv) of the format given below.
Date,Name,Location
04/02/2012,A,India
,B,China
,C,USA
Like this I have 1000's of rows and many columns in all my files.
I need a shell script to copy down the Date(in this example column1) to the next 2 rows below(in the... (8 Replies)
Hi,
I have a requirement to convert rows into columns. data looks like:
c1,c2,c3,..
r1,r2,r3,..
p1,p2,p3,..
and so on..
output shud be like this:
c1,r1,p1,..
c2,r2,p2,..
c3,r3,p3,..
Thanks in advance, (12 Replies)
Hello Everyone,
I am trying to find a way to take a .csv file with 7 columns and a ton of rows (over 600,000) and remove the entire row if the cell in forth column is blank.
Just to give you a little background on why I am doing this (just in case there is an easier way), I am pulling... (3 Replies)
How can i get the duplicates rows from a file using unix, for example i have data like
a,1
b,2
c,3
d,4
a,1
c,3
e,5
i want output to be like
a,1
c,3 (4 Replies)
Discussion started by: ggupta
4 Replies
LEARN ABOUT DEBIAN
cut-diff
CUT-DIFF(1) Cutter's manual CUT-DIFF(1)NAME
cut-diff - show difference between 2 files with color
SYNOPSIS
cut-diff [option ...] file1 file2
DESCRIPTION
cut-diff is a diff command that uses diff feature in Cutter. It shows difference with color.
It's recommended that you use a normal diff(1) when you want to use with patch(1) or you don't need color.
OPTIONS --version
cut-diff shows its own version and exits.
-c [yes|true|no|false|auto], --color=[yes|true|no|false|auto]
If 'yes' or 'true' is specified, cut-diff uses colorized output by escape sequence. If 'no' or 'false' is specified, cut-diff never
use colorized output. If 'auto' or the option is omitted, cut-diff uses colorized output if available.
The default is auto.
-u, --unified
cut-diff uses unified diff format.
--context-lines=LINES
Shows diff context around LINES.
All lines are shown by default. When unified diff format is used, 3 lines are shown by default.
--label=LABEL, -L=LABEL
Uses LABEL as a header label. The first--label option value is used as file1's label and the second --label option value is used
asfile2's label.
Labels are the same as file names by default.
EXIT STATUS
The exit status is 0 for success, non-0 otherwise.
TODO: 0 for non-difference, 1 for difference and non-0 for errors.
EXAMPLE
In the following example, cut-diff shows difference between file1 and file2:
% cut-diff file1 file2
In the following example, cut-diff shows difference between file1 and file2 with unified diff format:
% cut-diff -u file1 file2
SEE ALSO diff(1)Cutter February 2011 CUT-DIFF(1)