Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Find Null values in Columns and fail execution by displaying error message

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Find Null values in Columns and fail execution by displaying error message
# 8  
Old 04-08-2015
Two of your requirements (excluding headers and exit with code 16 if fields 2 or 3 are empty in a file) can be fulfilled easily with
Code:
awk     'function PR()  {print FILENAME, V?": Null values " V:": All records good."}

         FNR==1         {next}
         !$2            {V=102}
         !$3            {V=103}

         FNR==2 && NR>2 {PR(); if (V) exit 16}

        ' FS="," pf_[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9].csv

Unfortunately, awk doesn't know if it is operationg on the last line of a file, so we'd need to save each line and then check for FNR==1 (or the END condition). Try yourself and come back if you hit a brick wall.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Check for null values in a columns. I have dozen of CSV files in a directory.

Hi Folks, I'm trying to write a simple file sanity check script. I have a directory with dozen CSV files containing id,edname,firstname,lastname,suffix,email. I like to write a awk script to check if first field contain a number and is not empty. and fields number 3,4 & 6 are not empty and... (3 Replies)
Discussion started by: dc34684
3 Replies

2. Shell Programming and Scripting

Multiple columns replace with null values.

I am trying to replace the partcular columns(Col3,col5,col20,col44,col55,co56,col59,col60,col61,col62,col74,col75,col88,col90,col91,col93,col94,col95) with empty Input file Col1,col2,col3,col4,col5------,col100 1,2,3,4,5,---------,100 3,4,5,6,7,---------,300 Output : ... (3 Replies)
Discussion started by: onesuri
3 Replies

3. Shell Programming and Scripting

Find for line with not null values at nth place in pipe delimited file

Hi, I am trying to find the lines in a pipe delimited file where 11th column has not null values. Any help is appreciated. Need help asap please. thanks in advance. (3 Replies)
Discussion started by: manikms
3 Replies

4. UNIX for Dummies Questions & Answers

Eliminate error message (/dev/null)?

I am trying to eliminate an error message from a script. This is the error message: find: stat() error /usr/openv/netbackup/db/images/KUMAX: No such file or directory if ]; then runthiscommand=`su nxadm -c "ssh -t $new3 exec /bin/sh -s">/tmp/filew3 2>/tmp/error.txt<<EOF ... (1 Reply)
Discussion started by: newbie2010
1 Replies

5. UNIX for Dummies Questions & Answers

Find duplicated values in two columns out of three

hi! could u help in the following? I have the data (long list!) that looks like (three coumns white space separated): rs3094315 0.0665173 742429 rs12562034 0.0738998 758311 rs3934834 0.396449 995669 rs9442372 0.402693 1008567 rs3737728 0.406271 1011278 rs6687776 0.435429 1020428 rs9651273... (4 Replies)
Discussion started by: kush
4 Replies

6. Shell Programming and Scripting

Check for null values in columns

Hi , I have below data with fixed with of 52 bytes having three columns value data. 01930 MA GLOUCESTER 02033 02025 COHASSET 01960 MA ... (3 Replies)
Discussion started by: sonu_pal
3 Replies

7. Shell Programming and Scripting

How to list Matching Directories OR NULL w/o error message?

I want to be able to get all the directories in a path into a variable array, BUT if there ARE NO directories I want the Variable to be NULL and not echo any error message! If there ARE directories, this will get the list of the directories whose name begins with the string "20":... (6 Replies)
Discussion started by: pgorbas
6 Replies

8. Shell Programming and Scripting

find error?? find / -name "something.txt" 2>/dev/null

why is this giving me errors? i type this in: find / -name "something.txt" 2>/dev/null i get the following error messages: find: bad option 2 find: path-list predicate-list :confused: (5 Replies)
Discussion started by: magiling
5 Replies

9. Shell Programming and Scripting

Need to return fail or pass from shell script on the basis of pl/sql code execution

Hi guys, I am quite new in shell scripting. I am tring to promote some oracle jobs into control-M. In control-M, I am calling a script which establishes a connection with database and execute some procedures. Now I want if that PL/sql Block got failed script should return failure to... (2 Replies)
Discussion started by: alok1301
2 Replies

10. Shell Programming and Scripting

How to check Null values in a file column by column if columns are Not NULLs

Hi All, I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Discussion started by: Mandab
7 Replies
Login or Register to Ask a Question

LEARN ABOUT MOJAVE

jrunscript

jrunscript(1)						      General Commands Manual						     jrunscript(1)

NAME

       jrunscript - command line script shell

SYNOPSIS

       jrunscript [ options ] [ arguments... ]

PARAMETERS

       options
	  Options, if used, should follow immediately after the command name.

       arguments
	  Arguments, if used, should follow immediately after options or command name.

DESCRIPTION

       jrunscript  is  a command line script shell. jrunscript supports both an interactive (read-eval-print) mode and a batch (-f option) mode of
       script execution. This is a scripting language independent shell. By default, JavaScript is the language used, but the  -l  option  can	be
       used  to  specify  a  different	language.  Through Java to scripting language communication, jrunscript supports "exploratory programming"
       style.

       NOTE: This tool is experimental and may not be available in future versions of the JDK.

OPTIONS

       -classpath path
	  Specify where to find the user's .class files that are accessed by the script.

       -cp path
	  This is a synonym for -classpath path

       -Dname=value
	  Set a Java system property.

       -Jflag
	  Pass flag directly to the Java virtual machine on which jrunscript is run.

       -l language
	  Use the specified scripting language. By default, JavaScript is used. Note that to use other scripting languages, you also need to spec-
	  ify the corresponding script engine's jar file using -cp or -classpath option.

       -e script
	  Evaluate the given script. This option can be used to run "one liner" scripts specified completely on the command line.

       -encoding encoding
	  Specify the character encoding used while reading script files.

       -f script-file
	  Evaluate the given script file (batch mode).

       -f -
	  Read and evaluate a script from standard input (interactive mode).

       -help
	  Output help message and exit.

       -?
	  Output help message and exit.

       -q
	  List all script engines available and exit.

ARGUMENTS

       If  [arguments...] are present and if no -e or -f option is used, then the first argument is the script file and the rest of the arguments,
       if any, are passed as script arguments. If [arguments..] and -e or -f option are used, then all [arguments..] are passed  as  script  argu-
       ments.  If [arguments..], -e and -f are missing, interactive mode is used. Script arguments are available to a script in an engine variable
       named "arguments" of type String array.

EXAMPLES

       Executing inline scripts

	  jrunscript -e "print('hello world')"
	  jrunscript -e "cat('http://java.sun.com')"

       Use specified language and evaluate given script file

	  jrunscript -l js -f test.js

       Interactive mode

	  jrunscript
	  js>print('hello world');
	  hello world
	  js>34 + 55
	  89
	  js> thread(function() { print('hello world'); }
	  hello world
	  js>

       Run script file with script arguments

	  jrunscript test.js arg1 arg2 arg3

       test.js is script file to execute and arg1, arg2 and arg3 are passed to script as script arguments. Script can access  these  using  "argu-
       ments" array.

SEE ALSO

       If JavaScript is used, then before evaluating any user defined script, jrunscript initializes certain built-in functions and objects. These
       JavaScript built-ins are documented in jsdocs.

								    06 Aug 2006 						     jrunscript(1)