02-12-2009
finding field count escaping the blank values
Hi All
I have a file.Below are few records of the file.
sample.txt
CPS,ES,843232910001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR735,ALL CALLS,01674840629
CPS,ES,843232670001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR734,ALL CALLS,01674840608
I need to find the count of the 6th field and it should not consider the blank and null values.
say if the total number of records are 10 and in that the 6th filed has 4 values and others are blank then it should give only count as 4 and not 10.
Kindly let me know how to proceed.
Thanks
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one pattern and count of that pattern.
Note:These are the samples of two files,but i can have more... (2 Replies)
Discussion started by: jerome Sukumar
2 Replies
2. Shell Programming and Scripting
Hello,
I have a record which split with "," I would like to check..if the field is empty and it will field "NIL" into the field.
input
45111,40404,peter,,0303403,0,030304,john,,9,0,
output
45111,40404,peter,NIL,0303403,0,030304,john,NIL,9,0, (8 Replies)
Discussion started by: happyv
8 Replies
3. Shell Programming and Scripting
I want to find the top N entries for a certain field based on the values of another field.
For example if N=3, we want the 3 best values for each entry:
Entry1 ||| 100
Entry1 ||| 95
Entry1 ||| 30
Entry1 ||| 80
Entry1 ||| 50
Entry2 ||| 40
Entry2 ||| 20
Entry2 ||| 10
Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies
4. Shell Programming and Scripting
hi
i have file as below , i want to add duplicate records like bell_bb to one record with valuve as 15 ( addition of both )
any oneline awk script to achive this ?
header 0
CAMPAIGN_NAME 1
Bell_BB 14
Bell_MONTHLY 803
SOLO_UNBEATABLE 644
Bell_BB 1
Bell_MONTHLY 25
SOLO_UNBEATABLE... (4 Replies)
Discussion started by: raghavendra.cse
4 Replies
5. Shell Programming and Scripting
Hi I have a file with contents like :
101,6789556897,0000795369 - seq - fmt_recs187] - avg_recs
101,4678354769,0000835783 - seq - fmt_recs98] - avg_recs
221,5679787008,0001344589 - seq - fmt_recs1283] - avg_recs
I need to find the sum of the all the values (which are in bold).
here... (6 Replies)
Discussion started by: rkrish
6 Replies
6. Shell Programming and Scripting
Find a blank field
Hi
I have set of fields that have some blank values, how to find that and get its line noumbers in output file.
Ex:
Col1 col2 col3
11 ss 103
12 104
13 105
14 se 106 (2 Replies)
Discussion started by: Shenbaga.d
2 Replies
7. Shell Programming and Scripting
Hello All,
I am trying a one liner for finding the number of null columns in every line of my flat file.
The format of my flat file is like this
a|b|c|d||||e|f|g|
a|b|c|d||||e|f|g|
I want to count the number of fields delimited by "|" which are blank.
In above case the count should be... (6 Replies)
Discussion started by: nnani
6 Replies
8. Shell Programming and Scripting
Hi All,
i have a file like
col1 col2 col3
13 24 NA
12 13 14
11 12 13
14 22 NA
18 26 NA
in this file if i found "NA" other values in the line are also replace by NA
Could you help me! (7 Replies)
Discussion started by: Shenbaga.d
7 Replies
9. Shell Programming and Scripting
Gents,
It is possible to generate a range of values according to column 1 and count the total of rows in the range.
example
input
15.3
15.5
15.8
15.9
16.0
16.1
16.8
17.0
17.5
18.0
output desired
15.0 - 15.9 = 4 (10 Replies)
Discussion started by: jiam912
10 Replies
SIZE(1) General Commands Manual SIZE(1)
NAME
size - print the size of the sections in an object file
SYNOPSIS
size [ option ... ] [ object ... ]
DESCRIPTION
Size (without the -m option) prints the (decimal) number of bytes required by the __TEXT, __DATA and __OBJC segments. All other segments
are totaled and that size is listed in the `others' column. The final two columns is the sum in decimal and hexadecimal. If no file is
specified, a.out is used.
The options to size(1) are:
- Treat the remaining arguments as name of object files not options to size(1).
-m Print the sizes of the Mach-O segments and sections as well as the total sizes of the sections in each segment and the total size of
the segments in the file.
-l When used with the -m option, also print the addresses and offsets of the sections and segments.
-x When used with the -m option, print the values in hexadecimal (with leading 0x's) rather than decimal.
-arch arch_type
Specifies the architecture, arch_type, of the file for size(1) to operate on when the file is a universal file. (See arch(3) for
the currently know arch_types.) The arch_type can be "all" to operate on all architectures in the file. The default is to display
only the host architecture, if the file contains it; otherwise, all architectures in the file are shown.
SEE ALSO
otool(1)
BUGS
The size of common symbols can't be reflected in any of the numbers for relocatable object files.
Apple Computer, Inc. July 28, 2005 SIZE(1)