Help required on AWK command


 
Thread Tools Search this Thread
# 1  
Data Help required on AWK command

I have two questions:

(Q1) I am using a loop and want to print a particular field of a table using the AWK command by accessing one row at a time by validating NR with the loop counter. I am using a command like this but it isn't working!

count=1
NAWK -F"|" -v var=$count 'NR == var { printf $5 }' file1


where, count is my loop counter variable;
file1 is the table to search.

I will appreciate if someone gives me a solution

(Q2) I am taking a name as input and storing it in a variable empname
Now, the situation is same as in question 1 and I have used a command:
NAWK -F"|" -v var=$count 'NR = var { printf $5 }' file1
in this case although I am using the variable count=1 for printing field 5 of the first row the answer is given according to the variable empname as if I have used a command something like
NAWK -F"|" -v var="${empname}" '$1 ~ var { printf $5 }' file1

I will appreciate if someone gives me an explanation of this
# 2  
count=1
awk -F"|" '$1 ~/'$count'/ {print $5}' file1
# 3  
The AWK help is not working

Hi,

Thank you for your initiative but the suggestion isn't working. Can you suggest something else.
# 4  
please check the following :
cat file1
1|aaa|bbb|ccc
2|xxx|yyy|zzz
3|mmm|nnn|ooo

$ count=2
$ awk -F"|" '$1 ~ /'$count'/ {print $2}' file1

output :
xxx
# 5  
Sorry, I should have given a bit of detail. My file is like this
CAT file1
abc |123 |abc123
bcd |234 |bcd234
cde |345 |cde345

In such a situation the command will not work. I want to extract one field from this file by scrolling through its individual lines which I want to do within a loop.

I also would like to ask something on your feedback too:
Now considering I upgrade my file as you suggested like
CAT file1
1 |abc |123 |abc123
2 |bcd |234 |bcd234
3 |cde |345 |cde345
.
.
100 |uvw |999 |uvw999
In this situation also your command will give erronous results. What should I do in such a situation?
# 6  
I also tried with a slight modification of your command

AWK -F"|" '$1 == /'$count'/ {prinf $4}' file1

but this didn't work either
# 7  
In my case the following command is working fine :
$ count=2
$ awk -F"|" '$1 ~ /'$count'/ {prinf $4}' file1

The below mentioned command won't work :
awk -F"|" '$1 == /'$count'/ {prinf $4}' file1
== won't work.

Please try the first command and send the error details.
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #789
Difficulty: Medium
Steve Wozniak was employed at Sun Microsystems before he founded Apple Computers.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Required Command in awk command

Hi Firends, I wanted to extract the first record of the file which starst with character say "X". And I tried an awk command which works when i try to execute it individually: awk 'substr($1,1,1)=="X"' inputfile.txt But when I use the same command in my script for which I am passing the... (2 Replies)
Discussion started by: Ajay Venkatesan
2 Replies

2. Shell Programming and Scripting

awk help required

Hello, I am trying to get an output from awk and have been unsuccessful so far. There is an input file which contains certain segments, that needs to be read and append with another data after matching the segment... Input file is as shown below ISA*00* *00* *01*781495650... (2 Replies)
Discussion started by: rakeshv
2 Replies

3. Shell Programming and Scripting

awk script required

File 1 ################### TRAIU DSKDL; SLLA ;LAKJA KJAJA NSAJAN JANAL AJKJA JAJALA KAKAK JA AKA AKA AJ A A PPIN TRY1 SANT1 PPIN TRY2 SANT2 PPIN TRY3 SANT3 PPIN TRY4 SANT4 PPIN TRY5 SANT5 AJJA NA ANA ANHDJLD ALJALJA AJLJAJD LALJAL ALJALJA ALJALJA (4 Replies)
Discussion started by: jaita
4 Replies

4. Shell Programming and Scripting

Awk help required

Hi All, I have 2 .csv files as below File1.csv name1,20,30,date1 name2,30,40,date1 File2.csv name1,25,35,date1 name2,45,55,date1 Can any one help me to add the 2nd and 3rd column of file1 and file2 and write the output into a new file as below name1,45,65,date1... (9 Replies)
Discussion started by: ajay547
9 Replies

5. Shell Programming and Scripting

Searching using awk - Help required

Hi... I am working on script to search some records in a file based on certain fields and each record is a ASCII fixed size. I was using awk to search based on certain condition. But the length of the record is too much that awk is giving syntax error near unexpected token `(' Request... (5 Replies)
Discussion started by: ysrikanth
5 Replies

6. Shell Programming and Scripting

Help required with awk/sed

Hi I have a file, with format like: column1|coulumn2|column3|column4 A|X|K|18 L|O|R|31,42,25 G|H|I|55,66 L|E|Q|25,31,94 output required: column1|coulumn2|column3|column4 A|X|K|18 L|O|R|31,25 L|E|Q|25,31 Input File Format: All columns are seperated using |, last column... (8 Replies)
Discussion started by: New to awk
8 Replies

7. Shell Programming and Scripting

Help required in sed or awk.

Hi All, I need to pick up data on both sides of "=" sign. For eg, following is the context that I have. 125.156.125.147=machine1 147.125.185.156=machine2 147.125.185.159=machine3 Can I have the ip address in one variable and machine name in another variable using sed or awk. ... (1 Reply)
Discussion started by: nua7
1 Replies

8. Cybersecurity

Help Required: Command to find IP address and command executed of a user

Hi, I am trying to write a script which would figure out who has run which command and their IP. As i dont have any clue as to which commands would do this job, i request some gurus to help me on this. Thanks Vishwas (2 Replies)
Discussion started by: loggedout
2 Replies

9. Shell Programming and Scripting

Help Required regarding wc command

Hi guys, I want to find the number of records in a particular file and store that value in any other variable. I am trying this below command but it is not working and giving me an error "Uninary Operator Expected". say I have taken a variable name 'count' in which I have to store the no. of... (7 Replies)
Discussion started by: dtidke
7 Replies

10. Shell Programming and Scripting

Help required on awk

Hi, I have a fixed with file, which have almost 10 records Sample File: ------------ AR 100 TTT BC 200 SSS DA 199 YYY AR 500 RRR PO 300 QQQ PB 800 PPP PC 150 OOO AR 111 CCC AD 321 LLL I Have to check for first two charactors and if its 'AR' i have to save those records to one... (3 Replies)
Discussion started by: meetavin
3 Replies

Featured Tech Videos