To find record having null value Post: 302988289

Sponsored Content

Top Forums Shell Programming and Scripting To find record having null value Post 302988289 by RavinderSingh13 on Friday 23rd of December 2016 01:25:15 AM

12-23-2016

Moderator

Hello ginrkf,

Could you please run following in a script form it should work then as follows.

Code:

awk -F"," 'function verify(var){
                                        num=split(var, A);
                                        for(i in A){
                                                        if($A[i]){
                                                                        p++
                                                                 }
                                                   };
                                        if(num==p) {
                                                         print $0 " with file name: " FILENAME>> "correct_lines"
                                                   };
                                        if(num!=p) {
                                                        print $0 " with file name: " FILENAME >> "incorrect_lines"
                                                   }
                                        p=""
                               }
           FILENAME=="Input_file1"   {
                                        verify("2");
                               }
           FILENAME=="Input_file2"   {
                                        verify("2,4")
                               }
          '   Input_file1    Input_file2

Output came for above is as follows.

Code:

cat incorrect_lines
134,,fg,mnm,mnb with file name: file1
1345,,fg,,mnsb with file name: file2

cat correct_lines
123,asd,fgh,nmb,pok with file name: file1
1235,afg,fgdf,nmbs,posk with file name: file2

Thanks,
R. Singh

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Find files which contain a null character

Hi, I would like to use grep to find files which contain NULL characters. I'm not sure how to represent the null character in the grep statement. Could anyone help please? Thanks! Helen :confused:

2. Shell Programming and Scripting

If statement falling over on a null record. Help please.

Okay i've got some code which reads a text file and loops through it and there a few if statements inside where one is failing (the one bolded). Basically the acc column contains a list of three digit access codes, some though have null records (i.e nothing in the field) so what I want to do is...

3. Shell Programming and Scripting

Find null fields in file

Hi All, I have some csv files out of which i want to find records which have empty values in either the 14th or 16th fields. The following is a sample. $cut -d',' -f14,16 SPS* | head -5 VOIP_ORIG_INFO,VOIP_DEST_INFO sip:445600709315@sip.com,sip:999@sip.com...

4. Shell Programming and Scripting

How can find Null value in If condition

Hi, i wrote If Conditions in my script, it's returns null and some values. but i am unable to find when Null value getting. bec we need modification according null vales. pls help me on this.

5. UNIX for Dummies Questions & Answers

Using /dev/null with grep and find

Hi, I am trying to display the filename in which a string was found after using find and grep. For this after some googling I found that this works: find -name "*.java" -exec grep "searchStr" {} /dev/null \; I wanted to know the difference between the above and the following: find -name...

6. Shell Programming and Scripting

Find out if few fields in a file are null

Hi, I've a pipe delimited file where I want to find out a number of lines where 1st 2nd and last field are null using awk/sed. Is it possible? Thanks

7. Shell Programming and Scripting

how to find null column

Hi, everyone I have a requirement as following: source file 1, abc, def, caaa 2, , cde, aaa 3, bcd, , adefefg I need find columns which contains null value, in above example, I need get two rows 2, , cde, aaa 3, bcd, , adefefg anybody has idea how to achive this ...

8. Shell Programming and Scripting

Egrep ERE to find null

Hello All, My apologies if a similar question has already been posted. I searched for "grep", "egrep" and "null" I'm having an issue with egrep and an extended regular expression. I'm doing a test for a job name. I would like to have the user enter a job name with no spaces and also test to...

9. Shell Programming and Scripting

How to find null column?

hi Gurus, I need find the null column in a file. my file like below abc, ,cde,def abc,ded,cdd,def abc, ,ddd,ccd aaa,bbb,ccc,ddd basic, I need to find the lines which second column is null Thanks in advance

10. Shell Programming and Scripting

Identify empty file with null record

Hi Team, I have a file abc.dat which is a empty file. But it has null record in first line. I need to identify this unique file and handle it separately. scenario 1: abc/dw> wc abc.dat 1 0 1 abc.dat abc/dw> cat abc.dat abc/dw> scenario 2: abc/dw> wc pqr.dat 0 0 0 pqr.dat...

LEARN ABOUT V7

diff3

DIFF3(1)						      General Commands Manual							  DIFF3(1)

NAME

       diff3 - 3-way differential file comparison

SYNOPSIS

       diff3 [ -ex3 ] file1 file2 file3

DESCRIPTION

       Diff3 compares three versions of a file, and publishes disagreeing ranges of text flagged with these codes:

       ====	       all three files differ

       ====1	       file1 is different

       ====2	       file2 is different

       ====3	       file3 is different

       The type of change suffered in converting a given range of a given file to some other is indicated in one of these ways:

       f : n1 a        Text is to be appended after line number n1 in file f, where f = 1, 2, or 3.

       f : n1 , n2 c   Text is to be changed in the range line n1 to line n2.  If n1 = n2, the range may be abbreviated to n1.

       The original contents of the range follows immediately after a c indication.  When the contents of two files are identical, the contents of
       the lower-numbered file is suppressed.

       Under the -e option, diff3 publishes a script for the editor ed that will incorporate into file1 all changes between file2 and file3,  i.e.
       the  changes  that  normally  would  be	flagged ==== and ====3.  Option -x (-3) produces a script to incorporate only changes flagged ====
       (====3).  The following command will apply the resulting script to `file1'.

		(cat script; echo '1,$p') | ed - file1

FILES

       /tmp/d3?????
       /usr/lib/diff3

SEE ALSO

       diff(1)

BUGS

       Text lines that consist of a single `.' will defeat -e.
       Files longer than 64K bytes won't work.

																	  DIFF3(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Find files which contain a null character

Discussion started by: Bab00shka

2. Shell Programming and Scripting

If statement falling over on a null record. Help please.

Discussion started by: TonyR

3. Shell Programming and Scripting

Find null fields in file

Discussion started by: rahulrathod

4. Shell Programming and Scripting

How can find Null value in If condition

Discussion started by: koti_rama