Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Check for null values in a column Post 302304253 by ganesh_248 on Monday 6th of April 2009 01:07:21 AM
Old 04-06-2009
Bug

Quote:
Originally Posted by vidyadhar85
all test unix commands like grep ,sed awk etc etc.. work on line you will get very very few commands in unix which act on full file at once so if you find any let me knowSmilie
Vidyadar,i can read line by line and check whether the particular column has NULL or NOT.But i receive Huge files and they come in batches of 100's.so opening each and every file and reading it line by line consumes lot of time.I am trying out if there is any other possibility to create a shell script that is efficient and less time consuming for this problem.:-)
Please do let me know if u find any command bro' .
 

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Discussion started by: amigarus
6 Replies

3. UNIX for Dummies Questions & Answers

shift values in one column as header for values in another column

Hi Gurus, I have a tab separated text file with two columns. I would like to make the first column values as headings for the second column values. Ex. >value1 subjects >value2 priorities >value3 requirements ...etc and I want to have a file >value1 subjects >value2 priorities... (4 Replies)
Discussion started by: Unilearn
4 Replies

4. 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

5. Shell Programming and Scripting

Check to identify duplicate values at first column in csv file

Hello experts, I have a requirement where I have to implement two checks on a csv file: 1. Check to see if the value in first column is duplicate, if any value is duplicate script should exit. 2. Check to verify if the value at second column is between "yes" or "no", if it is anything else... (4 Replies)
Discussion started by: avikaljain
4 Replies

6. Shell Programming and Scripting

Check null values column

hi, I had a small question.I had a file from which i need to extract data. I have written the below script to check if the file exists and if it exists extract requierd columns from the file. IFILE=/home/home01/Report_1.csv OFILE=/home/home01/name.csv.out1 if #Checks if file exists... (1 Reply)
Discussion started by: Vivekit82
1 Replies

7. Shell Programming and Scripting

Script to check for null values in a column

Hi Guys, I am new to shell script.I need your help to write a shell script. I have a csv file which has 13 columns separated by , I have written below script to fetch required 5 columns. awk -F, '(NR==1){h3=$3;h4=$4;h8=$8;h9=$9;h13=$13;next}(NF>1) \ {print... (5 Replies)
Discussion started by: Vivekit82
5 Replies

8. Shell Programming and Scripting

Check increment values in column

Gents, I have a file where i would like to check the constant increment by 2 in column 2. 5450 1000 5450 1002 5450 1004 5450 1006 5465 1000 5465 1002 5465 1006 5465 1008 5550 1002 5550 1004 5550 1006 5550 1008 6830 1000 6830 1002 6830 1008 6830 1010 (6 Replies)
Discussion started by: jiam912
6 Replies

9. UNIX for Dummies Questions & Answers

Check for not null column in a pipe delimited file

Hi, I have a requirement where I have to check whether the mandatory columns in a pipe delimited file is null and print error message. For eg, I have to check if the 3rd,5th,6th,7th and 8th column are null and print the message "<column name> is null". The data file will have aroung 100,000... (6 Replies)
Discussion started by: reshma15193
6 Replies

10. 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
sed(1)							      General Commands Manual							    sed(1)

Name
       sed - stream text editor

Syntax
       sed [-n] [-e script] [-f sfile] [file...]

Description
       The  command  copies  the  named  files	(standard input default) to the standard output, edited according to a script of commands.  The -f
       option causes the script to be taken from file sfile; these options accumulate.	If there is just one -e option and no -f's,  the  flag	-e
       may  be omitted.  The -n option suppresses the default output; inclusion in the script of a comment command of the form also suppresses the
       default output.	(See the description of the `#' command.)

       A script consists of editing commands of the following form:

	      [address [, address] ] function [arguments]

       Nominally, there is one command per line; but commands can be concatenated on a line by being separated with semicolons

       In normal operation cyclically copies a line of input into a pattern space (unless there is something left after a `D' command), applies in
       sequence all commands whose addresses select that pattern space, and at the end of the script copies the pattern space to the standard out-
       put (except under -n) and deletes the pattern space.

       An address is either a decimal number that counts input lines cumulatively across files, a `$' that addresses the last line of input, or  a
       context address, `/regular expression/', in the style of ed(1) modified thus:

	  o    In  a  context  address, the construction ?regular expression?, where ? is any character, is identical to regular expression. Note
	       that in the context address xabcxdefx, the second x stands for itself, so that the regular expression is abcxdef.

	  o    The escape sequence `
' matches a new line embedded in the pattern space.

	  o    A command line with no addresses selects every pattern space.

	  o    A command line with one address selects each pattern space that matches the address.

	  o    A command line with two addresses selects the inclusive range from the first pattern space that matches the first  address  through
	       the  next  pattern  space  that matches the second.  (If the second address is a number less than or equal to the line number first
	       selected, only one line is selected.)  Thereafter the process is repeated, looking again for the first address.

       Editing commands can be applied only to non-selected pattern spaces by use of the negation function `!' (below).

       In the following list of functions the maximum number of permissible addresses for each function is indicated in parentheses.

       An argument denoted text consists of one or more lines, all but the last of which end with `' to hide the new line.  Backslashes  in  text
       are  treated  like  backslashes in the replacement string of an `s' command, and may be used to protect initial blanks and tabs against the
       stripping that is done on every script line.

       An argument denoted rfile or wfile must terminate the command line and must be preceded by exactly one blank.  Each wfile is created before
       processing begins.  There can be at most 10 distinct wfile arguments.

       (1)a
       text
	       Append.	Place text on the output before reading the next input line.

       (2)b label
	       Branch to the `:' command bearing the label.  If label is empty, branch to the end of the script.

       (2)c
       text
	       Change.	 Delete  the  pattern space.  With 0 or 1 address or at the end of a 2-address range, place text on the output.  Start the
	       next cycle.

       (2)d    Delete the pattern space.  Start the next cycle.

       (2)D    Delete the initial segment of the pattern space through the first new line.  Start the next cycle.

       (2)g    Replace the contents of the pattern space by the contents of the hold space.

       (2)G    Append the contents of the hold space to the pattern space.

       (2)h    Replace the contents of the hold space by the contents of the pattern space.

       (2)H    Append the contents of the pattern space to the hold space.

       (1)i
       text
	       Insert.	Place text on the standard output.

       (2)n    Copy the pattern space to the standard output.  Replace the pattern space with the next line of input.

       (2)N    Append the next line of input to the pattern space with an embedded new line.  (The current line number changes.)

       (2)p    Print.  Copy the pattern space to the standard output.

       (2)P    Copy the initial segment of the pattern space through the first new line to the standard output.

       (1)q    Quit.  Branch to the end of the script.	Do not start a new cycle.

       (2)r rfile
	       Read the contents of rfile.  Place them on the output before reading the next input line.

       (2)s/regular expression/replacement/flags
	       Substitute the replacement string for instances of the regular expression in the pattern space.	Any character may be used  instead
	       of `/'.	For a more complete description see The flags is zero or more of

	       g       Global.	Substitute for all nonoverlapping instances of the regular expression rather than just the first one.

	       p       Print the pattern space if a replacement was made.

	       w wfile Write.  Append the pattern space to wfile if a replacement was made.

       (2)t label
	       Test.   Branch  to  the `:' command bearing the label if any substitutions have been made since the most recent reading of an input
	       line or execution of a `t'.  If label is empty, branch to the end of the script.

       (2)w wfile
	       Write.  Append the pattern space to wfile.

       (2)x    Exchange the contents of the pattern and hold spaces.

       (2)y/string1/string2/
	       Transform.  Replace all occurrences of characters in string1 with the corresponding character in string2.  The lengths  of  string1
	       and string2 must be equal.

       (2)! function
	       Don't.  Apply the function (or group, if function is `{') only to lines not selected by the address(es).

       (0): label
	       This command does nothing; it bears a label for `b' and `t' commands to branch to.

       (1)=    Place the current line number on the standard output as a line.

       (2){    Execute the following commands through a matching `}' only when the pattern space is selected.

       (0)     An empty command is ignored.

       (0)#    With one exception, any line whose first nonblank character is a number sign is a comment and is ignored.  The exception is that if
	       the first such line encountered contains only the number sign followed by the letter `n' the default output is suppressed as if the
	       -n option were in force.

Options
       -e 'command;command...'
	       Uses command;command...	as the editing script.	If no -f option is given, the -e keyword can be omitted.  For example, the follow-
	       ing two command are functionally identical:
	       % sed -e 's/DIGITAL/Digital/g' summary > summary.out
	       % sed 's/DIGITAL/Digital/g' summary > summary.out

       -f sfile
	       Uses specified file as input file of commands to be executed.  Can be used with -e option to apply both	explicit  commands  and  a
	       separate script file.

       -n      Suppresses  all	normal	output, writing only lines explicitly written by the `p' or `P' commands or by an `s' command with the `p'
	       flag.

See Also
       awk(1), ed(1), grep(1), lex(1)

																	    sed(1)
All times are GMT -4. The time now is 11:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy