12-12-2002
deleting records with a missing field
I had to delete rows when a record was missing a field. My solution was
cut -c 202-402 ${dataFile} | awk '{if (substr($0,103,30) !~ /^ *$/) print $0} >> ${workFile}
The cut is because they came two records to a row.
Anyone want to offer a more elegant solution?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Gentle Unix users,
Can someone tell me how I can use a combination of the cat and grep command to display records that are in FileA but missing in FileB.
cat FileA one line at a time and grep to see if it is in fileB. If it is ignore.
If line is not in fileB display the line.
Thanks in... (4 Replies)
Discussion started by: jxh461
4 Replies
2. UNIX for Advanced & Expert Users
Hi,
I have two files say A and B, Both files have some common records few records which are unique to file A and unique to file B.
Can anyone please help me out to find the records which are present in only B
Please consider the files are of too large size.
Thanks:confused: (1 Reply)
Discussion started by: Shiv@jad
1 Replies
3. Shell Programming and Scripting
I have a very big file of 5gb size and there are about 50 million records in there. I have to delete the records based on recrord number that I know fromoutside with out opening the file. The record numbers are very random like 5000678, 7890005 etc.
Can somebody let me know how i can... (5 Replies)
Discussion started by: dsravan
5 Replies
4. Shell Programming and Scripting
can you please give shell script for daleting the last 7 records of file... (7 Replies)
Discussion started by: vsairam
7 Replies
5. Shell Programming and Scripting
Hello,
I'm have a file of xy data with over 1000 records. I want to delete both x and y values for any record that has the same x value as any previous record thus removing the duplicates from my file.
Can anyone help?
Thanks,
Dan (3 Replies)
Discussion started by: DFr0st
3 Replies
6. Shell Programming and Scripting
I have 2 files
"File 1" is delimited by ";" and "File 2" is delimited by "|".
File 1 below (3 record shown):
Doc1;03/01/2012;New York;6 Main Street;Mr. Smith 1;Mr. Jones
Doc2;03/01/2012;Syracuse;876 Broadway;John Davis;Barbara Lull
Doc3;03/01/2012;Buffalo;779 Old Windy Road;Charles... (2 Replies)
Discussion started by: vestport
2 Replies
7. Shell Programming and Scripting
I have a excel sheet with contains the records as below..
also uploaded the input excelsheet and the output excel sheet(expected output).
322mpls32.net.xyz.comBW: 44.0 M Hrly Avg (IN /... (1 Reply)
Discussion started by: giridhar276
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I need to delete one row from a .dat file.
error processing column PCT_USED in row 1053295 for datafile /exp/stats/ts_stats.dat
ORA-01722: invalid number
This is used to load records using sql loader.
Please let me know the procedure to do it.
Regards,
VN (3 Replies)
Discussion started by: narayanv
3 Replies
9. Shell Programming and Scripting
Hi,
Can any one help me, in deleting the records from the database table based on the following condition:
script should take a configurable parameter as input. The input is nothing but “no. of years”.
For example, if I enter 2 as input parameter, then the 2 year old records should get... (2 Replies)
Discussion started by: zxcjggu708
2 Replies
10. Shell Programming and Scripting
I have a fixed width file. The records looks something similar to below:
Type ID SSN NAME .....AND SOME MORE FIELDS
A1 1234 .....
A1 1234 .....
B1 1234 .....
M2 4567 .....
M2 4567 .....
N2 4567 .....
N2 4567 .....
A1 9999
N2 9999
Now if A1 is present then B1 has to be present.... (2 Replies)
Discussion started by: Saanvi1
2 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)