09-18-2007
How to grep
Hi ,
How to check in a delimited : ", " file in unix, to count how many
records have missing info on any particular column in the header file?
Ex: Cntry,PST_DT,CC_CD,Amt (header info)
IL,23OCT2005,840,1.00 (data)
Basically I need to check how many records have missing information in "AMT" column. Any shred on what I need??
thanks in advance,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys,
I need to set the value of $7 to zero in case $7 is NULL. I've tried the below command but doesn't work. Any ideas. thanks guys.
MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else { print $7}}' `
Harby. (4 Replies)
Discussion started by: hariza
4 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I looking to use grep to return a string with exactly n matches.
I'm building off this:
ls -aLl /bin | grep '^.\{9\}x' | tr -s ' '
-rwxr-xr-x 1 root root 632816 Nov 25 2008 vi
-rwxr-xr-x 1 root root 632816 Nov 25 2008 view
-rwxr-xr-x 1 root root 16008 May 25 2008... (7 Replies)
Discussion started by: MykC
7 Replies
3. UNIX for Dummies Questions & Answers
Hello,
I'm working on unix with grep (GNU grep) 2.5.1. I'm going through some of the newer regex syntax using Regular Expression Reference - Advanced Syntax a guide.
ls -aLl /bin | grep "\(x\)"
Which works, just highlights 'x' where ever, when ever.
I'm trying to to get (?:) to work but... (4 Replies)
Discussion started by: MykC
4 Replies
4. Shell Programming and Scripting
Hi All, I need to grep few files which has words like the below in the file name , which i want to put it in a file and and grep for the files which contain these names and move it to a new directory ,
full file name -C20091210.1000-20091210.1100_SMGBSC3:1000... (2 Replies)
Discussion started by: anita07
2 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
Please i need to know the difference between grep, egrep & grep -i when used to serach through a file.
My platform is SunOS 5.9 & i'm using the korn shell.
Regards,
- divroro12 - (2 Replies)
Discussion started by: divroro12
2 Replies
6. UNIX for Dummies Questions & Answers
I have a directory I need to grep which consists of numbered sub directories. The sub directory names change daily. A file resides in this main directory that shows which sub directories are FULL backups or INCREMENTAL backups.
My goal is to grep the directory for the word "full" and then... (2 Replies)
Discussion started by: SysAdm2
2 Replies
7. Shell Programming and Scripting
I have an input file
12.4 1.72849432773174e+01 -7.74784188610632e+01
12.5 9.59432114416327e-01 -7.87018212757537e+01
15.6 5.20139995965960e-01 -5.61612429666624e+01
29.3 3.76696387248366e+00 -7.42896194101892e+01
32.1 1.86899877018077e+01 -7.56508762501408e+01
35 6.98857157014640e+00... (2 Replies)
Discussion started by: chrisjorg
2 Replies
8. UNIX for Dummies Questions & Answers
Hello.
I want to get all modules which are loaded and which name are exactly 2 characters long and not more than 2 characters and begin with "nv"
lsmod | (e)grep '^nv????????????
I want to get all modules which are loaded and which name begin with "nv" and are 2 to 7 characters long
... (1 Reply)
Discussion started by: jcdole
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a number of files containing the information below.
"""""
Fundallinfo
6.3950 14.9715 14.0482
"""""
I would like to grep for Fundallinfo and use it to read the next line? I ideally would like to read the three numbers that follow in the next line and... (2 Replies)
Discussion started by: Paul Moghadam
2 Replies
10. Shell Programming and Scripting
i have this line of code that looks for the same file if it is currently running and returns the count.
`ps -eaf -o args | grep -i sfs_pcard_load_file.ksh | grep -v grep | wc -l`
basically it is assigned to a variable
ISRUNNING=`ps -eaf -o args | grep -i sfs_pcard_load_file.ksh |... (6 Replies)
Discussion started by: wtolentino
6 Replies
LEARN ABOUT DEBIAN
lire::report::columninfo
ColumnInfo(3pm) LogReport's Lire Documentation ColumnInfo(3pm)
NAME
Lire::Report::ColumnInfo - Object that holds column meta-data.
SYNOPSIS
my $info = $subreport->column_info_by_idx( 0 );
print "Column's name: ", $info->name(), "
";
print "Column's index: ", $info->index(), "
";
print "Column's type: ", $info->type(), "
";
print "Column's label: ", $info->label(), "
";
DESCRIPTION
The Lire::Report::ColumnInfo object contains meta-data information on the columns of a subreport.
CONSTRUCTOR
new( $group, $name, $class, $type, [$label]])
Creates a new Lire::Report::ColumnInfo object. The column info attributes are initialized based on $name, $class, $type and $label.
OBJECT METHODS
name()
Returns the name of this column. This name can be used to find the group operation (from the report specification) that is responsible for
the column's content.
class()
Returns the column's class of data. This will be either 'numerical' or 'categorical'.
type()
Returns the column's type. This referes to the type of the DLF field that was usd to generate this column's values.
group_info()
Returns the GroupInfo object which contains this column.
index()
Returns the column's index in the table. This will be undef until the column info object is added to a Lire::Subreport or Lire::Group
object.
col_start()
Returns the display column which is the start of the cell span that should be used to render this column's values.
col_end()
Returns the display column which is the end of the cell span that should be used to render this column's values.
col_width()
Returns the suggested column width for this column in characters.
max_chars()
This method returns the length of the longest string in that column (including the label).
avg_chars()
This method returns the average length of strings in that column (including the label). This will be round up to the next integer (1.3 ->
2).
label( [$label] )
Returns the column's label. If the $label parameter is defined, the column's label will be set to this new value.
SEE ALSO
Lire::Report::Subreport(3pm) Lire::Report::GroupInfo(3pm)
VERSION
$Id: ColumnInfo.pm,v 1.15 2006/07/23 13:16:31 vanbaal Exp $
COPYRIGHT
Copyright (C) 2002 Stichting LogReport Foundation LogReport@LogReport.org
This file is part of Lire.
Lire is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
AUTHOR
Francis J. Lacoste <flacoste@logreport.org>
Lire 2.1.1 2006-07-23 ColumnInfo(3pm)