disregarding space when using awk print


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers disregarding space when using awk print
# 1  
Old 10-09-2012
disregarding space when using awk print

Hi guys,

I have this output, wherein the device is variable and changing values

Code:
Device  Identifier        Type   Dir:P
------  ----------------  -----  ----------------
3065    10000000c986cdb0  FIBRE  FA-10A:1
        10000000c9866716  FIBRE  FA-11A:1

I want to filter column 2 which has wwns

im using this but doesnt seem to work. please help.

Code:
symmaskdb -sid $A\ -dev $D list assign | sed -e 's/$D//g' | grep FIBRE | awk '{print $1}'

output is
Code:
3065
10000000c9866716

and my desired output is

Code:
10000000c986cdb0  
10000000c9866716

# 2  
Old 10-09-2012
you don't need grep and awk separately.

try this..


Code:
awk '/FIBRE/{for(i=1;i<=NF;i++){if($i == "FIBRE"){print $(i-1)}}}' file

This User Gave Thanks to pamu For This Post:
# 3  
Old 10-09-2012
Code:
 
$ awk '/FIBRE/&&NF==3{print $1;next}/FIBRE/{print $2}' input.txt
10000000c986cdb0
10000000c9866716

# 4  
Old 10-09-2012
Code:
awk '/FIBRE/ {print $(NF-2)}' inputfile

This User Gave Thanks to RudiC For This Post:
# 5  
Old 10-09-2012
for this specific case , searching of FIBRE may solve the issue.
When searching on assignment for multiple devices , there can be devices mapped to SCSI ports or Mainframe ports . This might work better in those cases.

Code:
awk '( NR>2) { print $(NF-2) }' filname


Last edited by Scrutinizer; 10-10-2012 at 04:03 AM..
This User Gave Thanks to penchal_boddu For This Post:
# 6  
Old 10-09-2012
great, all of the suggestion works! thanks everyone.

can some one tell me what is NR for in awk? just for my future reference.

from the output above how can i also filter my final output to be like

Code:
10000000c986cdb0  10A  1

because when i print NF it displays FA-10A:1

i need to remove FA-(probably be sed or any other method), and separate 10A and 1 with space instead of a colon.
# 7  
Old 10-09-2012
Code:
awk -F'[ -:]' '( NR>2) { print $(NF-6) , $(NF-1) , $NF  }' filename


Last edited by Scrutinizer; 10-10-2012 at 04:03 AM.. Reason: code tags
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Command to print columns with space

Hello I am trying to pull specific columns from an output file that contains spaces and make it a variable.. Here is a piece of the output file and my command: Host1 UNIX /vol/volume/my stuff When I pull in the data into my variable the word stuff is left off - I need this as part of my... (10 Replies)
Discussion started by: fmalvest
10 Replies

2. Shell Programming and Scripting

Print 1 to 10 with space in shell script

Hi, I want to print 1 to 10 or upto any number sequentially with space in a single line. Like, 1 2 3 4 5 6 7 ...... In shell script only.. Can anyone plz help me. Thanks: (14 Replies)
Discussion started by: arup1980
14 Replies

3. UNIX for Advanced & Expert Users

Need to remove leading space from awk statement space from calculation

I created a awk state to calculate the number of success however when the query runs it has a leading zero. Any ideas on how to remove the leading zero from the calculation? Here is my query: cat myfile.log | grep | awk '{print $2,$3,$7,$11,$15,$19,$23,$27,$31,$35($19/$15*100)}' 02:00:00... (1 Reply)
Discussion started by: bizomb
1 Replies

4. Shell Programming and Scripting

awk print used space

Hi Team, Can you please tell me how to get a used space in KB LINUX and free space in KB separate commands. For example: $df -k /rer (apdfp01.xxx.com:/var/adm/rash/MT) : 2066900 total allocated Kb 4579 free allocated Kb 16121 used allocated Kb 89 % allocation used /dev/deviceFS1... (5 Replies)
Discussion started by: indira_s
5 Replies

5. Shell Programming and Scripting

Print pattern regardless of space between

I have this content in file sshd : ALL : allow SSHD : all : ALLOW sshD : All : AllOW What I need is to print the occurrence of "sshd:all" regardless of the spaces between them and if lower/upper case. So all lines should be printed in output when "grepped" or "printed... (3 Replies)
Discussion started by: anil510
3 Replies

6. Shell Programming and Scripting

awk until blank space and print next line

Hello and Happy New Year 2012! I have this example: 1,2,3 4,5,6 7,8,9 For that, I'm trying to get: 1,2,3 4,5,6 7,8,9 for that, I think this might work but doesnt work so far: awk '{for(i=1;i=NF;i++);sub(/\//,"",$i);print $i}' myfile (2 Replies)
Discussion started by: Gery
2 Replies

7. Shell Programming and Scripting

awk or sed command to print specific string between word and blank space

My source is on each line 98.194.245.255 - - "GET /disp0201.php?poc=4060&roc=1&ps=R&ooc=13&mjv=6&mov=5&rel=5&bod=155&oxi=2&omj=5&ozn=1&dav=20&cd=&daz=&drc=&mo=&sid=&lang=EN&loc=JPN HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.0.3705; .NET CLR... (5 Replies)
Discussion started by: elamurugu
5 Replies

8. Shell Programming and Scripting

Find a pattern and print next all character to next space

Hi, I have a big inventory file that is NOT sorted is any way. The file is have "tagged" information like the ip address "*IP=" or the name "*NM=" . How do I get just the ip address or the name and not the whole line? I have tried to use AWK without any success. I always get the whole line... (8 Replies)
Discussion started by: pierrebjarnfelt
8 Replies

9. Shell Programming and Scripting

way to print all the string till we get a space and a number

Is there any way to print all the string till we get a space and a number and store it a variable for eg we have string java.io.IOException: An existing connection was forcibly closed by the remote host 12 All I want is to store "java.io.IOException: An existing connection was forcibly closed... (13 Replies)
Discussion started by: villain41
13 Replies

10. Shell Programming and Scripting

print disk space warning of 70%

Hi All, I have a script that run every night to check disk space. echo "Warning: Disk with 70%~79% used" && df -k | grep .% I want the echo should go out only if there's a FS usage findings of 70%+. I want a simple shell script, not with if and then script. Thank you for any comments... (1 Reply)
Discussion started by: itik
1 Replies
Login or Register to Ask a Question