10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello
I have a file like this
a,b,c,1,2,3,d,e,f,,,,g,h,i,,,,j,k,l
and using awk 'FS="'"{print $9,$10,$11}' does not work as I was hoping. I would like the empty fieds, i.e. between the two comma to be interpreted as a zero. is this possible?
I would like to get f 0 0 out of the above... (1 Reply)
Discussion started by: garethsays
1 Replies
2. Shell Programming and Scripting
Hi Team,
I have a file abc.dat which is a empty file. But it has null record in first line. I need to identify this unique file and handle it separately.
scenario 1:
abc/dw> wc abc.dat
1 0 1 abc.dat
abc/dw> cat abc.dat
abc/dw>
scenario 2:
abc/dw> wc pqr.dat
0 0 0 pqr.dat... (3 Replies)
Discussion started by: kmanivan82
3 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I've got a file that has 12 fields. I've merged 2 files and there will be some duplicates in the following:
FILE:
1. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, 100
2. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, (EMPTY)
3. CDC, 54321, TEST3,... (4 Replies)
Discussion started by: tugar
4 Replies
4. Shell Programming and Scripting
How to write in awk to remove lines starting with "#" and then process the file:
This is not working:
cat file|awk '{if ($0 ~ /^#/) $0="";print NF>0}'
When I just give cat file|awk '{if ($0 ~ /^#/) $0="";print }'
it prints the blank lines . I don't wnat the blank lines along with the... (15 Replies)
Discussion started by: rveri
15 Replies
5. Shell Programming and Scripting
I have the following awk script to which I pass the file
>
10 0 0
10 0 0
>
12.997 0 5.71132
12.9098 0.0687626 5.48855
12.7506 0.174324 5.13225
12.5913 0.262662 4.80643
12.4316 0.335652 4.50283
12.2717 0.394598 4.21542
12.1113 0.440399 3.93957
11.9506 0.473646 3.67148
11.7894... (2 Replies)
Discussion started by: kristinu
2 Replies
6. Shell Programming and Scripting
hello
I have a file with lines of info separated with "|"
I want to amend the second field of the last line, using AWK
my problem is with geting awk to return the last line
this is what I am using
awk 'END{ print $0 }' myFile
but I get an empty result
I tried the... (13 Replies)
Discussion started by: TasosARISFC
13 Replies
7. Shell Programming and Scripting
Hi,
Does any one know how to avoid the scenario where awk ignores the fields having only spaces or empty fields?
for instance,
Data: "a","b","c","d",""," "
code:
awk -F, '{ print NF }' File
the output I get is 4 instead of 6 do you know how to avoid this? (6 Replies)
Discussion started by: ahmedwaseem2000
6 Replies
8. Shell Programming and Scripting
Hi suppose I have a csv file like this
count,1977,1978,1979
usa, , , blue
japan, red, yellow,green
india, , yellow,blue
china, blue, yellow, green
I want the output to be(replace everything, including empty data, with the most recent data):
... (1 Reply)
Discussion started by: grossgermany
1 Replies
9. Shell Programming and Scripting
I have a script with this statement:
/usr/xpg4/bin/awk -F"" 'NR==FNR{s=$2;next}{printf "%s\"%s\"\n", $0, s}' LOOKUP.TXT finallistnew.txt >test.txt
I want to include logic or an additional step that says if there is no data in field 3, move the whole line out of test.txt into an additional... (9 Replies)
Discussion started by: scriptr2be
9 Replies
10. Shell Programming and Scripting
Hi
Wrote the below script to identify the empty directories ,when executing the below showing that directory is not empty but the directories are empty.Please help to identify the empty directories
33 is not empty
33 is not empty
33 is not empty
33 is not empty
for file in `find .... (5 Replies)
Discussion started by: mohan705
5 Replies