finding null records in data file Post: 302102298

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

concatenating static string to records in data file

I just need to add a static ID to each output record so the users will be able to tell which group records in combined flatfiles come from I have the static ID in a bourne variable. I tried awk '{print "${GroupID}" $0}' infile > outfile But I ended up with the string ${GroupID} instead of...

2. Shell Programming and Scripting

awk script required for finding records in 1 file with corresponding another file.

Hi, I have a .txt file (uniqfields.txt) with 3 fields separated by " | " (pipe symbol). This file contains unique values with respect to all these 3 fields taken together. There are about 40,000 SORTED records (rows) in this file. Sample records are given below. 1TVAO|OVEPT|VO...

3. Shell Programming and Scripting

exclude records with null fields

Hi, can I do something like this to add a condition of checking if the 4th field is number or space or blank also: awk -F, '$4 /^*||*/' MYFILE >> OTHERFILE I also want the other part i.e. I need to exclude all lines whose 4th field is space or blank or number: MYFILE a,b,c,d,e a,b,c,2,r...

4. Shell Programming and Scripting

Extract data from large file 80+ million records

Hello, I have got one file with more than 120+ million records(35 GB in size). I have to extract some relevant data from file based on some parameter and generate other output file. What will be the besat and fastest way to extract the ne file. sample file format :--...

5. Shell Programming and Scripting

Awk to Count Records with not null

Hi, I have a pipe seperated file I want to write a code to display count of lines that have 20th field not null. nawk -F"|" '{if ($20!="") print NR,$20}' xyz..txt This displays records with 20th field also null. I would like output as:

6. UNIX and Linux Applications

Initializing columns to NULL an saving data to a new file

Hi I've been trying to delete columns from a file, and the best option I could come up was to initialise them to NULL. The reason for this is because I need to compare the differences between 2 files with those specific columns excluded. Here is my script: #!/bin/bash...

7. Shell Programming and Scripting

Finding Data in the file

Hi All I have a file having columns such as AAA,BBB,CCC,Aug 13 2013 AAA,BBB,CCC,Aug 11 2013 AAA,BBB,CCC,Aug 12 2013 AAA,BBB,CCC,Aug 13 2013 Now I need to extract the records which are not of todays date (Considering Today date is 13-Aug-2013 So I should get below records...

8. Shell Programming and Scripting

UNIX scripting for finding duplicates and null records in pk columns

Hi, I have a requirement.for eg: i have a text file with pipe symbol as delimiter(|) with 4 columns a,b,c,d. Here a and b are primary key columns.. i want to process that file to find the duplicates and null values are in primary key columns(a,b) . I want to write the unique records in which...

9. Shell Programming and Scripting

How can I retrieve the matching records from data file mentioned?

XYZNA0000778800Z 16123000012300321000000008000000000000000 16124000012300322000000007000000000000000 17234000012300323000000005000000000000000 17345000012300324000000004000000000000000 17456000012300325000000003000000000000000 9 XYZNA0000778900Z 16123000012300321000000008000000000000000...

10. UNIX for Beginners Questions & Answers

Finding records NOT on another file

I have three files named ALL, MATCH, and DIFF. Match and diff have completely different records included in the "all" file, but the "all" file also has records not in either the Match or Diff files. I know I can sort all three files together, one unique and one without that option to show which...

LEARN ABOUT DEBIAN

edos-rpmcheck

EDOS-RPMCHECK(1)					      General Commands Manual						  EDOS-RPMCHECK(1)

NAME

       Edos-rpmcheck - Check satisfiability of rpm package dependencies

SYNOPSIS

       edos-rpmcheck [option] ... [package] ...

DESCRIPTION

       edos-rpmcheck  reads  from  standard  input  a set of rpm package descriptions. Packages may appear with multiple versions in this set. For
       instance, an uncompressed hdlist.cz is suitable as input.

       We say that a package is identified in this set by the pair consisting of the package name and of the package version.

       A package (called goal) is called installable with respect to a set of packages if there exists a subset of the packages that
	- contains at most one version for each package name
	- contains the goal package (in any version, or a specific version)
	- all packages of the subset have their dependencies and conflicts satisfied in this subset.

       Edos-rpmcheck checks whether every package given as argument is installable with respect to the input set of  packages.	Specific  versions
       can be specified by following the package name with the sign '=' and the version of the package (for instance, 'xemacs21=21.4.17-1'). If no
       package name is given as argument then all packages of the input set are checked for satisfiability.

       The constraint solving algorithm is complete, that is it finds a solution whenever there exists one, even for multiple  disjunctive  depen-
       dencies	and  deep  package  conflicts. This problem is computationally infeasible in theory (that is, NP-complete), but can in practice be
       solved very efficiently.

OPTIONS

       -explain
	      Explain the results

       -rules Print generated rules

       -failures
	      Only show failures

       -successes
	      Only show successes

       -base file
	      Specifiy an additional file providing packages that are not checked but used for resolving dependencies

       -quiet Supress warnings and progress/timing messages

       -xml   Output results in XML format

       -help, --help
	      Display this list of options

EXAMPLE

       Check which packages in a particular distribution are not installable and why:

	 gunzip -c hdlist.cz | edos-rpmcheck -failures -explain

       where hdlist.cz is the file pertaining to that distribution.

       Check whether version 21.4.17-1 of the xemacs21 package is installable in a distribution described by the file Packages:

	 gunzip -c hdlist.cz | edos-rpmcheck -explain xemacs=21.4.17-1

AUTHOR

       Edos-rpmcheck has been written by Jerome Vouillon for the EDOS project. This man-page has been compiled by Ralf Treinen.

SEE ALSO

       <http://www.edos-project.org> is the home page of the EDOS project.

       edos-debcheck(1) is the analogous tool for debian packages.

EDOS
								    2006-05-20							  EDOS-RPMCHECK(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

concatenating static string to records in data file

Discussion started by: gillbates

2. Shell Programming and Scripting

awk script required for finding records in 1 file with corresponding another file.

Discussion started by: RRVARMA

3. Shell Programming and Scripting

exclude records with null fields

Discussion started by: praveenK_Dudala

4. Shell Programming and Scripting

Extract data from large file 80+ million records

Discussion started by: learner16s