Grep


 
Thread Tools Search this Thread
# 1  
Grep

i have file input

Code:
dadadasdasdw_02> cab |egrep -i '(active|cbu)'

130502-11:49:20 10.164.25.153 9.0j  stopfile=/tmp/14975
Trying password from ipdatabase file: /opt/ericsson/amos/moshell/sitefiles/ipdatabase...
..  0   1  CBU1      OFF    ON     16HZ    ROJ1192209/1   R5G    TU8G444668 20080917 +42C *

i expect to have output

Code:
dadadasdasdw_02,42C

i did this

nawk '/egrep -i/ { x = $1 } /*/ { print x, $12 }' OFS="," input| tr -d ">"

but the resut is null
# 2  
I have assumed few things here..

Code:
 
awk '/egrep/{FS=">";v=$1};/^Trying/{FS=" ";getline;sub(/\+/,"",$0);print v","$(NF-1)}' filename

# 3  
an error
nawk: trying to access field -1
input record number 925, file 1
source line number 1


my complete file input

Code:
  dgdfgfhdfagfadsf> cab |egrep -i '(active|cbu)'
   
  130502-11:32:32 10.133.1.152 9.0j  stopfile=/tmp/6139
  Trying password from ipdatabase file: /opt/ericsson/amos/moshell/sitefiles/ipdatabase...
  ..  0   1  DUW3001  OFF    ON     OFF     KDU127161/3    R4E    TU8X688156 20120619 52C  Active
   
  dsgfdgdfgd> cab |egrep -i '(active|cbu)'
   
  130502-11:34:11 10.133.1.153 9.0j  stopfile=/tmp/15959
  Trying password from ipdatabase file: /opt/ericsson/amos/moshell/sitefiles/ipdatabase...
  ..  0   1  CBU1      OFF    ON     16HZ    ROJ1192209/1   R5E    TU8BZ04466 20070928 +51C *
   
  afdgfdgdgg> cab |egrep -i '(active|cbu)'
   
  130502-12:21:24 10.128.7.1 9.0j  stopfile=/tmp/26600
  Trying password from ipdatabase file: /opt/ericsson/amos/moshell/sitefiles/ipdatabase...
  ...  0   1  CBU1      OFF    ON     16HZ    ROJ1192209/1   R5G    A400740608 20080811 +44C *
   
  adasdasdasd> cab |egrep -i '(active|cbu)'
   
  130502-12:21:24 10.128.7.1 9.0j  stopfile=/tmp/26600
  Trying password from ipdatabase file: /opt/ericsson/amos/moshell/sitefiles/ipdatabase...
  ...  0   1  CBU1      OFF    ON     16HZ    ROJ1192209/1   R5G    A400740608 20080811 +44C Active


i did

Code:
nawk '/egrep -i/ { x = $1 } /Active/ { print x, $12 }' OFS="," file1 | tr -d ">" > output
nawk '/egrep/{FS=">";v=$1};/^Trying/{FS=" ";getline;sub(/\+/,"",$0);print v","$(NF-1)}' file1">" >> output

grep "C$" output

---------- Post updated at 06:16 AM ---------- Previous update was at 06:13 AM ----------

expected output
Code:
dgdfgfhdfagfadsf,52C
dsgfdgdfgd,51C
afdgfdgdgg,44C
adasdasdasd,44C

# 4  
Does your data file has leading spaces? if yes try below command only and dont add your nawk or grep to it

Code:
 
awk '/egrep/{FS=">";v=$1};/Trying/{FS=" ";getline;sub(/\+/,"",$0);print v","$(NF-1)}'  filename

# 5  
when i execute the code youve suggested, the output is just like the input
# 6  
Quote:
Originally Posted by radius
when i execute the code youve suggested, the output is just like the input
Its hard to do guess work when we cant see the file. As per your data in the thread the code i gave should work.

Its tough to do guess work/fix Smilie

Last edited by vidyadhar85; 05-02-2013 at 08:58 AM..
 

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

Test Your Knowledge in Science: Computers
Difficulty: Medium
FLAC stands for "Free Lossless Audio Condenser"'
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inconsistent `ps -eaf -o args | grep -i sfs_pcard_load_file.ksh | grep -v grep | wc -l`

i have this line of code that looks for the same file if it is currently running and returns the count. `ps -eaf -o args | grep -i sfs_pcard_load_file.ksh | grep -v grep | wc -l` basically it is assigned to a variable ISRUNNING=`ps -eaf -o args | grep -i sfs_pcard_load_file.ksh |... (6 Replies)
Discussion started by: wtolentino
6 Replies

2. UNIX for Dummies Questions & Answers

Piping grep into awk, read the next line using grep

Hi, I have a number of files containing the information below. """"" Fundallinfo 6.3950 14.9715 14.0482 """"" I would like to grep for Fundallinfo and use it to read the next line? I ideally would like to read the three numbers that follow in the next line and... (2 Replies)
Discussion started by: Paul Moghadam
2 Replies

3. UNIX for Dummies Questions & Answers

Bash - CLI - grep - Passing result to grep through pipe

Hello. I want to get all modules which are loaded and which name are exactly 2 characters long and not more than 2 characters and begin with "nv" lsmod | (e)grep '^nv???????????? I want to get all modules which are loaded and which name begin with "nv" and are 2 to 7 characters long ... (1 Reply)
Discussion started by: jcdole
1 Replies

4. Shell Programming and Scripting

AWK/GREP: grep only lines starting with integer

I have an input file 12.4 1.72849432773174e+01 -7.74784188610632e+01 12.5 9.59432114416327e-01 -7.87018212757537e+01 15.6 5.20139995965960e-01 -5.61612429666624e+01 29.3 3.76696387248366e+00 -7.42896194101892e+01 32.1 1.86899877018077e+01 -7.56508762501408e+01 35 6.98857157014640e+00... (2 Replies)
Discussion started by: chrisjorg
2 Replies

5. UNIX for Dummies Questions & Answers

Advanced grep'in... grep for data next to static element.

I have a directory I need to grep which consists of numbered sub directories. The sub directory names change daily. A file resides in this main directory that shows which sub directories are FULL backups or INCREMENTAL backups. My goal is to grep the directory for the word "full" and then... (2 Replies)
Discussion started by: SysAdm2
2 Replies

6. UNIX for Dummies Questions & Answers

Difference between grep, egrep & grep -i

Hi All, Please i need to know the difference between grep, egrep & grep -i when used to serach through a file. My platform is SunOS 5.9 & i'm using the korn shell. Regards, - divroro12 - (2 Replies)
Discussion started by: divroro12
2 Replies

7. Shell Programming and Scripting

grep for certain files using a file as input to grep and then move

Hi All, I need to grep few files which has words like the below in the file name , which i want to put it in a file and and grep for the files which contain these names and move it to a new directory , full file name -C20091210.1000-20091210.1100_SMGBSC3:1000... (2 Replies)
Discussion started by: anita07
2 Replies

8. UNIX for Dummies Questions & Answers

| help | unix | grep (GNU grep) 2.5.1 | advanced regex syntax

Hello, I'm working on unix with grep (GNU grep) 2.5.1. I'm going through some of the newer regex syntax using Regular Expression Reference - Advanced Syntax a guide. ls -aLl /bin | grep "\(x\)" Which works, just highlights 'x' where ever, when ever. I'm trying to to get (?:) to work but... (4 Replies)
Discussion started by: MykC
4 Replies

9. UNIX for Dummies Questions & Answers

| help | unix | grep - Can I use grep to return a string with exactly n matches?

Hello, I looking to use grep to return a string with exactly n matches. I'm building off this: ls -aLl /bin | grep '^.\{9\}x' | tr -s ' ' -rwxr-xr-x 1 root root 632816 Nov 25 2008 vi -rwxr-xr-x 1 root root 632816 Nov 25 2008 view -rwxr-xr-x 1 root root 16008 May 25 2008... (7 Replies)
Discussion started by: MykC
7 Replies

10. Shell Programming and Scripting

MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else

Hi Guys, I need to set the value of $7 to zero in case $7 is NULL. I've tried the below command but doesn't work. Any ideas. thanks guys. MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else { print $7}}' ` Harby. (4 Replies)
Discussion started by: hariza
4 Replies

Featured Tech Videos