instead of writing print command in awk, i saw in some posts that we can simply write a number before we end the awk command and it will print the file.
As given below:
I also tried replacing the 1 in above command with some other numbers and it worked.
I just want to know what exactly happens when we put this number, n how the command woorks.
I'm having a file with 5 fields.
I want to sort that file according to one field
no 3. How shall I do using awk programming.
Any input appreciatable.
regards,
vadivel. (7 Replies)
hi
how to get the values in two columns (may be 2nd and 5th column) of a file line by line.
either i want to get the two fields into different variables and use a for loop to get these values line by line. (3 Replies)
i have a file like this:
awk.lst
smith : sales : 1200 : 2
jones:it:25000 : 2
roger : it : 1500 : 2
ravi | acct | 15000
i have 3 doubts
1)
when i say
awk -F ":" '$2 ~ /'it'/ {print $0}' awk.lst
i am not able to get jones in the ouput , is it because of space issue?
2)how to... (2 Replies)
Hello people
I have a doubt about awk... I´m using it to create a condition where I do not want to use the 0 (zero) value of a certain column.
- This is the original file:
string,number,date
abc,0,20050101
def,1,20060101
ghi,2,20040101
jkl,12,20090101
mno,123,20020101... (2 Replies)
I have executed the below command:
find . -name "Ks*" -type f -exec ls -ltr {} \; | awk '{printf("%ld %s %d %s \n",$5,$6,$7,$8,$9)}'
and here is the output:
1282 Oct 7 2004
51590 Jul 10 2006
921 Oct 7 2004
1389 Jun 4 2003
1037 May 19 2004
334 Mar 24 2004
672 Jul 8 2003
977... (6 Replies)
I have a file sample.txt with the following contents:
the following gives output as
awk 'NF{s=$0; print s}' sample.txt
but,
awk 'NF{s=$0}{print s}' sample.txtgives output as
why this difference, can someone explain me? (6 Replies)
DE_CODE|1{AXXANY}1APP_NAME|2{TELCO}2LOC|NY
DE_CODE|1{AXXATX}1APP_NAME|2{TELCO}2LOC|TX
DE_CODE|1{AXXABT}1APP_NAME|2{TELCO}2LOC|BT
DE_CODE|1{AXXANJ}1APP_NAME|2{TELCO}2LOC|NJ
i have out put file like below i have to convert it in the format as below.
DE_CODE = AXXANY
APP_NAME= TELCO
LOC = NY... (4 Replies)
Hi,
I got a below requirement from this forum, but the solution provided was not clear.
Below is the requirement
Input file
A 1 Z
A 1 ZZ
B 2 Y
B 2 AA
Required output
B Y|AA
A Z|ZZ (5 Replies)