Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk expression to find one or more zeros
Top Forums Shell Programming and Scripting awk expression to find one or more zeros Post 302093461 by hnhegde on Thursday 19th of October 2006 02:45:17 PM
Old 10-19-2006
awk expression to find one or more zeros
Hi,

We have a flat file with an account number column . Some of the account numbers are just zeros. e.g., 0, 000, 000000.
I am trying to pick out such records which have only zeros in their account number column (column #8). I tried an awk expression :
Code:
awk '{ FS=" "}{if ( match($8, "0+") ) printf "..........."}'

But this returns all account numbers which have one or more zeros along with those that have just zeros. e.g., 0003456, 09008765 are also returned, where as these are valid numbers.

How should I refine the regular expression, so that only records with zeros in the 8th column are returned?

Thanks!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Can't find the mistake in sed expression

Hi there, Can anyone help me find the correct expression for sed. I want to repace iface eth0 inet wathever with iface eth0 inet static Thanks for your help Santiago (5 Replies)
Discussion started by: chebarbudo
5 Replies

2. Shell Programming and Scripting

find expression with awk in only one column, and if it fits, print whole column

Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column. 1 apple oranges 2 bannanas pears 3 cats dogs 4 hesaid shesaid echo "which number:" read NUMBER (user inputs number 2 for this example) awk " /$NUMBER/ {field to search is field... (2 Replies)
Discussion started by: glev2005
2 Replies

3. Shell Programming and Scripting

appending zeros to numbers using awk

hi i want to append zeros to a given number ( varying digits). the total length of the output should be 10 digits. For example: 1)input is var=347 output should be NewVar=0000000347 2) input is var=123456 output should be NewVar=0000123456 i am able to acheive this using typeset... (1 Reply)
Discussion started by: somi2yoga
1 Replies

4. Shell Programming and Scripting

awk to remove leading zeros for a hex number

Is it possible by using awk to remove leading zeros for a hex number? ex: 0000000011179E0A -> 11179E0A Thank you! (4 Replies)
Discussion started by: carloszhang
4 Replies

5. Shell Programming and Scripting

Find, regular expression, anyway to simplify this find command?

Hello everyone, first post here, trying to learn scripting on my own and this forum as been really helpful so far. I made few little scripts working great but I m facing some problems with RE. I have a bunch of files in many subdirectories called *001.ext *002.ext OR simple *.ext or *01.ext... (7 Replies)
Discussion started by: Sekullos
7 Replies

6. UNIX for Dummies Questions & Answers

[Solved] Using awk to obtain minimum of each column (ignoring zeros)

Hi, I have a wide and long dataset which looks as follows: 0 3 4 2 3 0 2 2 ... 3 2 4 0 2 2 2 3 ... 0 3 4 2 0 4 4 4 ... 3 0 4 2 2 4 2 4 ... .... I would like to obtain the minimum of each column (ignoring zero values) so the output would look like: 3 2 4 2 2 2 2 2 I have the... (3 Replies)
Discussion started by: kasan0
3 Replies

7. Shell Programming and Scripting

Find filenames with three digits and add zeros to make five digits

Hello all! I've looked all over the internet and this site and have come up a loss with an easy way to make a bash script to do what I want to do. I have a file with a naming convention as follows: 2012-01-18 string of words here 123.jpg 2012-01-18 string of words here 1234.jpg 2012-01-18... (2 Replies)
Discussion started by: Buzzman25
2 Replies

8. UNIX for Dummies Questions & Answers

How to using Regular expression to find file.?

Hi Gurus, I need to identify the file with below format: ABC20110101.DAT ABCD2011010103.DAT If I use ABC*\.DAT, it get two file. I want to get file after "ABC' then number, the ".DAT". I tried ABC* but it doesn't work. Thanks in advance. (9 Replies)
Discussion started by: ken6503
9 Replies

9. Shell Programming and Scripting

How to find a value from an expression?

I have below expression from which I would like to output +m= value: "ginger bread.k +log ../output1 -format +m=3 0 +sleep 10 +suspend 10" The output value should be "3" Any suggestions? (2 Replies)
Discussion started by: bskumarb4u
2 Replies

10. Shell Programming and Scripting

How to find regular expression for two files?

I have files: sum_<INPUT FILENAME>.YYYYMMDDhhmmss.csv and sum_details_<INPUT FILENAME>.YYYYMMDDhhmmss.csv I have no idea, what is input filename, but in the code I would like to catch them in case I process them in the loop above case statement for *.${Today}.*.txt... (3 Replies)
Discussion started by: digioleg54
3 Replies

LEARN ABOUT DEBIAN

nl

NL(1)								   User Commands							     NL(1)

NAME

       nl - number lines of files

SYNOPSIS

       nl [OPTION]... [FILE]...

DESCRIPTION

       Write each FILE to standard output, with line numbers added.  With no FILE, or when FILE is -, read standard input.

       Mandatory arguments to long options are mandatory for short options too.

       -b, --body-numbering=STYLE
	      use STYLE for numbering body lines

       -d, --section-delimiter=CC
	      use CC for separating logical pages

       -f, --footer-numbering=STYLE
	      use STYLE for numbering footer lines

       -h, --header-numbering=STYLE
	      use STYLE for numbering header lines

       -i, --line-increment=NUMBER
	      line number increment at each line

       -l, --join-blank-lines=NUMBER
	      group of NUMBER empty lines counted as one

       -n, --number-format=FORMAT
	      insert line numbers according to FORMAT

       -p, --no-renumber
	      do not reset line numbers at logical pages

       -s, --number-separator=STRING
	      add STRING after (possible) line number

       -v, --starting-line-number=NUMBER
	      first line number on each logical page

       -w, --number-width=NUMBER
	      use NUMBER columns for line numbers

       --help display this help and exit

       --version
	      output version information and exit

       By default, selects -v1 -i1 -l1 -sTAB -w6 -nrn -hn -bt -fn.  CC are two delimiter characters for separating logical pages, a missing second
       character implies :.  Type \ for .  STYLE is one of:

       a      number all lines

       t      number only nonempty lines

       n      number no lines

       pBRE   number only lines that contain a match for the basic regular expression, BRE

       FORMAT is one of:

       ln     left justified, no leading zeros

       rn     right justified, no leading zeros

       rz     right justified, leading zeros

AUTHOR

       Written by Scott Bartram and David MacKenzie.

REPORTING BUGS

       Report nl bugs to bug-coreutils@gnu.org
       GNU coreutils home page: <http://www.gnu.org/software/coreutils/>
       General help using GNU software: <http://www.gnu.org/gethelp/>
       Report nl translation bugs to <http://translationproject.org/team/>

COPYRIGHT

       Copyright (C) 2011 Free Software Foundation, Inc.  License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
       This is free software: you are free to change and redistribute it.  There is NO WARRANTY, to the extent permitted by law.

SEE ALSO

       The full documentation for nl is maintained as a Texinfo manual.  If the info and nl programs are properly installed at your site, the com-
       mand

	      info coreutils 'nl invocation'

       should give you access to the complete manual.

GNU coreutils 8.12.197-032bb					  September 2011							     NL(1)
All times are GMT -4. The time now is 03:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy