11-02-2006
compare null with non-null
I've got a very peculiar situation. I'm trying to find out if we can compare null fields with non-null. I've output csv files from SQL and Oracle. I need to compare each field from the files, and then find out any differences. The files usualy have over 500 fields, and send the resule to DBA.
Here is the intersting part, some fields may have different value, but thats ok. Like time stamps from SQL and Oracle. What I really need is to compare fields with null and non-null values. If SQL has non-null value and corresponding Oracle also has non-null then it's good. Though the values can be different some times. But a null value and same field on other file has non-null value, then I would like to extract that and report.
Any idea or suggestions? I've been looking in to diff, cmp, and even awk.
Thanks in advance
-Nitin
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello All,
I have a file of the format
****
123 abc ABC
456 bcd BCD
789 def
112 ghi GHI
223 jkl
344 mno MNO
****
I am trying to extract the lines that have no values in the third field (in this case, this would be
789 def
223 jkl
Can anyone please help??... (1 Reply)
Discussion started by: Khoomfire
1 Replies
2. Shell Programming and Scripting
hello all,
In many shell scripts i found '> /dev/null' , i am not able to get this,
will any one please explain why we are using this.
thanks
sudha (2 Replies)
Discussion started by: rrs
2 Replies
3. UNIX for Dummies Questions & Answers
Hi
I have a input file with many fields and each filed will be with in double quotes(""). i want to check fields contains balnk,null or space using condition using if. when i write code as below for if condition its not working
a=`awk -F ',' '{gsub("\"", "", $1);'NF==0';printf $1}'... (3 Replies)
Discussion started by: jayakumarrt
3 Replies
4. Shell Programming and Scripting
Hi expert,
May I know what is the difference between below cron tab entry ?
0,12 * * * * /abc/myscript.sh > /dev/null 2>&1
0,12 * * * * /abc/myscript.sh (7 Replies)
Discussion started by: olaris
7 Replies
5. Shell Programming and Scripting
when do you use the path /dev/null (3 Replies)
Discussion started by: webmunkey23
3 Replies
6. UNIX for Advanced & Expert Users
Hi,
Can someone help me comparing Null values.
Scenario is as follows:
I have a variable which "cache_prd" which can have either some integer or nothing(Null)
if it is integer I have to again do some comparision but these comparisons give me this error:( "line 32: [: 95: unary operator... (3 Replies)
Discussion started by: Yagami
3 Replies
7. Shell Programming and Scripting
I have an input file having 7 fields delimited by ,
eg :
1,ABC,hg,1,2,34,3
2,hj,YU,2,3,4,
3,JU,kl,4,5,7,
4,JK,KJ,3,56,4,5
The seventh field here in some lines is empty, whereas the other lines there is a value.
How do I insert string NULL at this location (7th loc) for these lines where... (8 Replies)
Discussion started by: zilch
8 Replies
8. UNIX for Dummies Questions & Answers
How are these two different? They both prevent output and error from being displayed. I don't see the use of the "&"
echo "hello" > /dev/null 2>&1
echo "hello" > /dev/null 2>1 (3 Replies)
Discussion started by: glev2005
3 Replies
9. Shell Programming and Scripting
Hi Champs!!!
im a newbie in unix, need ur expert help for my problem...
I need to search if there are any "NULL" entries in the string
String without Null
Str1: 203652|1000003653|tellt|RUPV|4649|1|07/28/2011 01:56:12
String with Null (RUPV is removed)
Str2:... (5 Replies)
Discussion started by: guruprasad7
5 Replies
10. Shell Programming and Scripting
I apologize if this question has been answered else where or is too elementary.
I ran across a KSH script (long unimportant story) that does this:
if ; then
CAS_SRC_LOG="/var/log/cas_src.log 2>&1"
else
CAS_SRC_LOG="/dev/null 2>&1"
fithen does this:
/usr/bin/echo "heartbeat:... (5 Replies)
Discussion started by: jbmorrisonjr
5 Replies
tar(4) Kernel Interfaces Manual tar(4)
NAME
tar - format of tar tape archive
DESCRIPTION
The header structure produced by (see tar(1)) is as follows (the array size defined by the constants is shown on the right):
All characters are represented in ASCII. There is no padding used in the header block; all fields are contiguous.
The fields magic, uname, and gname are null-terminated character strings. The fields name, linkname, and prefix are null-terminated char-
acter strings except when all characters in the array contain non-null characters, including the last character. The version field is two
bytes containing the characters (zero-zero). The typeflag contains a single character. All other fields are leading-zero-filled octal
numbers in ASCII. Each numeric field is terminated by one or more space or null characters.
The name and the prefix fields produce the pathname of the file. The hierarchical relationship of the file is retained by specifying the
pathname as a path prefix, with a slash character and filename as the suffix. If the prefix contains non-null characters, prefix, a slash
character, and name are concatenated without modification or addition of new characters to produce a new pathname. In this manner, path-
names of at most 256 characters can be supported. If a pathname does not fit in the space provided, the format-creating utility notifies
the user of the error, and no attempt is made to store any part of the file, header, or data on the medium.
SEE ALSO
tar(1)
STANDARDS CONFORMANCE
tar(4)