05-09-2012
Hi Sir
They are 4 lines in the file.
One line is what i mentioned earlier
POPULATION,69691,20120509
From each line i just need to get the second value,
I studied the awk command and understood what you mean,
But i need to do it for all 4 lines in that file and each line based on the first word..ie., POPULATION and need 69691 from that line for further scripting.
How do I use awk command and see whether the second value is not 0.
here 69691 is not 0..then i proceed to do somemore scripting.
Thank You...I learnt a new command awk after your post.
Can you pls, help me with writing it for the above line and matching whether the second line is not 0.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
Input is comma delimited. How to convert every second comma ',' to a new line character.
I know tr ',' '\n' <filename will convert every occarance.
Input :
1,5,6,4,9,..n
Output:
1,5
6,4
9,..
Thanks in advance. (3 Replies)
Discussion started by: deepakwins
3 Replies
2. Shell Programming and Scripting
Hi,
I am trying to truncate word after comma in a file ONLY if there are already 2 words BEFORE comma. If there is one word or 3 or more words BEFORE comma, then I have to leave the data AS IS. See below for example.
Input File :
John Smith, Manager
Smith, John Frank
J F K... (2 Replies)
Discussion started by: msalam65
2 Replies
3. Shell Programming and Scripting
Hello, Unix-Forums!
1.23456789
This an example number. It can be any number. I want grep to only find the digits behind the "."
That means
23456789
should be the output in this case.
How would I do that? (2 Replies)
Discussion started by: intelinside
2 Replies
4. Shell Programming and Scripting
Hi,
I am newbie in unix.
Could someone tell me how do I redirect my grep output to a csv/excel ?
I have used below command but the outputs are appearing in one column Not in different column.
grep -e cmd -e cmd1 test.txt | cut -f 5 | sort | uniq -c> op.csv
I do not understand how do I... (14 Replies)
Discussion started by: kmajumder
14 Replies
5. Shell Programming and Scripting
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies
6. Shell Programming and Scripting
I,
I have a file and i need to replace comma and blank space with comma and 0.
cat file.txt
a,5
b,1
c,
d,
e,4
I need the output as
cat file.txt
a,5
b,1
c,0
d,0 (4 Replies)
Discussion started by: jaituteja
4 Replies
7. Shell Programming and Scripting
I have a comma delimited file of major codes and descriptions. I want to replace all occurrences of spaces with underscores up to the first comma (only in the first field), but not replace spaces following the comma. For instance I have the following snippet of the file:
EK ED,Elementary and... (7 Replies)
Discussion started by: tdouty
7 Replies
8. Shell Programming and Scripting
Hi Gurus,
I need to remove comma from first and last line. I tried below code, but no luck. It only remove first line.
Gurus, please help.
awk -F"," '{if(NR==1||NR==$NR) print $1; else print $0}' TEST
sampe file:
ABC HEADER TOTAL RECORDS ARE 2.00,,,,... (13 Replies)
Discussion started by: ken6503
13 Replies
9. Shell Programming and Scripting
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 Replies
10. UNIX for Beginners Questions & Answers
can anyone help me!!!! How to I parse the CSV file
file name : abc.csv (csv file) The above file containing data like
abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies
IGAWK(1) Utility Commands IGAWK(1)
NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO
gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
Free Software Foundation Nov 3 1999 IGAWK(1)