Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Grep / awk /sed question

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Grep / awk /sed question
# 1  
Old 08-15-2013
Grep / awk /sed question
Hi All,

I have a file with following sample data. I am also attaching the file.

Code:
                                                       (Est)  (Est)    Jobs  Sch
Workstation      Job Stream       SchedTime   State Pr Start  Elapse   #  OK Lim
POOL            #ACR_BILLING      0005 08/15  STUCK 92 00:25  ( 0:14) 19   3          [Carry]; {0AAAAAAAAAAAAHDC}
POOL            #ACR_BILLING      1900 08/15  HOLD  92(19:00) ( 0:14) 19   0          [Carry]; {0AAAAAAAAAAAAGJP}
POOL            #ACR_BILLING_OUT  0200 08/15  STUCK 94 02:06  ( 0:15) 14   5          {0AAAAAAAAAAAAFKD}
POOL            #AFA              0005 08/15  STUCK 94 00:22  ( 0:42) 39   6          [Carry]; {0AAAAAAAAAAAAHDK}
POOL            #AFA              1900 08/15  HOLD  94(19:00) ( 0:42) 39   0          [Carry]; {0AAAAAAAAAAAAGKJ}
POOL            #AIR_POST_ERROR_Q 0005 08/15  STUCK 86 00:34  ( 0:17)  7   4          [Carry]; {0AAAAAAAAAAAAHDS}
POOL            #AIR_POST_ERROR_Q 1900 08/15  HOLD  86(19:00) ( 0:17)  7   0          [Carry]; {0AAAAAAAAAAAAGLD}
POOL            #AUTOPOSTS        0005 08/15  STUCK 92 00:24  ( 0:30) 30   7          [Carry]; {0AAAAAAAAAAAAHD2}
POOL            #AUTOPOSTS        1900 08/15  HOLD  92(19:00) ( 0:30) 30   0          [Carry]; {0AAAAAAAAAAAAGL5}
POOL            #AUTOPOST_HNDBACK 0000 08/15  HOLD  10        ( 0:12) 12   0          {0AAAAAAAAAAAAFKM}


I need details of "Job Stream" "SchedTime" and its corresponding id to be stored in a file next to each other so that i can use it further.

For example ACR_BILLING the SchedTime is 0005 08/15 and corresponding id is 0AAAAAAAAAAAAHDC

The output i am expecting is as below...

Code:
Job Stream              SchedTime        Stream ID
ACR_BILLING      0005 08/15       0AAAAAAAAAAAAHDC
ACR_BILLING      1900 08/15       0AAAAAAAAAAAAGJP

and so on....
sample.txt (5.9 KB) 
# 2  
Old 08-15-2013
Simple approach with awk
Code:
awk -F"[ #{}]+" '/^POOL/ {print $2,$3,$4,$(NF-1)}'

You have some line in your file that are some different from other, what to do with them.
POOL#LTY_ENGINE_CALL3[(1900 08/15/13),(0AAAAAAAAAAAAGRT)].@
This User Gave Thanks to Jotne For This Post:
Kevin Tivoli
# 3  
Old 08-15-2013
Sorry forgot to mention about that. The other lines like below which are located at right hand side of the page. I don't need them as they will be cover in the regular lines.

Code:
                                                                                      POOL#LTY_ENGINE_CALL3[(1900 08/15/13),(0AAAAAAAAAAAAGRT)].@
                                                                                      POOL#AUTOPOSTS[(1900 08/15/13),(0AAAAAAAAAAAAGL5)].@
                                                                                      POOL#LTY_ENGINE_CALL7[(1900 08/15/13),(0AAAAAAAAAAAAGU3)].@
                                                                                      POOL#LTY_ENGINE_CALL1[(1900 08/15/13),(0AAAAAAAAAAAAGP7)].@
                                                                                      POOL#LTY_ENGINE_CALL4[(1900 08/15/13),(0AAAAAAAAAAAAGSN)].@
                                                                                      POOL#LTY_ENGINE_CALL6[(1900 08/15/13),(0AAAAAAAAAAAAGUB)].@
                                                                                      POOL#LTY_ENGINE_CALL2[(1900 08/15/13),(0AAAAAAAAAAAAGQZ)].@
                                                                                      POOL#LTY_ENGINE_CALL5[(1900 08/15/13),(0AAAAAAAAAAAAGTH)].@

---------- Post updated at 02:49 PM ---------- Previous update was at 02:19 PM ----------

Awesome. Thanks a ton :-)

---------- Post updated at 02:50 PM ---------- Previous update was at 02:49 PM ----------

Quote:
Originally Posted by Jotne
Simple approach with awk
Code:
awk -F"[ #{}]+" '/^POOL/ {print $2,$3,$4,$(NF-1)}'

You have some line in your file that are some different from other, what to do with them.
POOL#LTY_ENGINE_CALL3[(1900 08/15/13),(0AAAAAAAAAAAAGRT)].@



Awesome. Thanks a ton :-) Works like a Charm
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Question grep and sed

hi everybody i have this script and it work's if i use a single variable in grep, but when i put $searchterm_ the script stops work i have a problem too in sed, because i don't know how i can search and replace more than one item, in this case is >>> $searchterm/$replaceterm and... (4 Replies)
Discussion started by: felito
4 Replies

2. Shell Programming and Scripting

awk/grep type question

Hi there, I have a Solaris machine with an ifconfig output similar to below lo0: flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> mtu 8232 index 1 inet 127.0.0.1 netmask ff000000 e1000g0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 2 inet... (2 Replies)
Discussion started by: hcclnoodles
2 Replies

3. Shell Programming and Scripting

awk vs grep question

Hello, I am trying to use awk instead of grep command. Is there a way I can search for a pattern and show 10 lines before it (grep -B) using awk ot nawk? (5 Replies)
Discussion started by: alekkz
5 Replies

4. UNIX for Dummies Questions & Answers

sed/grep string replace question

Hi all, I know this question has probably been answered before, but I am struggling with this problem, even after googling a million pages. In a file named rdmt.conf I need a single character replaced, the number in the line below CUR_OC4J_ID=1 It will always appear after... (3 Replies)
Discussion started by: Mike AAA
3 Replies

5. UNIX for Dummies Questions & Answers

grep/awk/sed?

Thread1 { x = 2 y = 10485 } Thread2 { x = 16 y = 1048 } Thread3 { x = 1 y = 1049 } Thread4 { x = 4 y = 1047 z = 500 } Suppose the above is a piece of code. I need to automate and verify that the value of x under Thread1's 2. There are several... (3 Replies)
Discussion started by: foxtron
3 Replies

6. Shell Programming and Scripting

General question about the relationship between KSH and sed/grep/awk etc

Greetings all, Unix rookie here, just diving into ksh scripting for the first time. My question may seem confusing but please bear with me: If I'm understanding everything I'm reading properly, it seems like the ksh language itself doesn't have a lot of string manipulation functions of... (2 Replies)
Discussion started by: DalTXColtsFan
2 Replies

7. Shell Programming and Scripting

grep or awk or sed not sure which to use here

Hi All, I have a huge file, I need to two things from this file. I need to know the IP address or the hostname and second thing is the date&time. The file looks like this and I need to get my data from this... Trying... Connected to 204.109.172.117. Escape character is '^]'. Fri... (4 Replies)
Discussion started by: samnyc
4 Replies

8. Shell Programming and Scripting

question on sed grep awk from variable

i am still confusing on how to use sed, grep and awk if the input is not a file but a variable. such as: a="hello world" b="how are you" c="best wish to you" d="222,333,444" what if i want to check which variable $a,$b,$c,$d have contain "you" what if i want to replace the word "you"... (9 Replies)
Discussion started by: 3Gmobile
9 Replies

9. Shell Programming and Scripting

sed / grep question

Hello, I am new to shell scripting. I have a input file: Few lines of the input file has the following. /a0012/abcd12/abcd12 /a0003/xyzab1/lmno123 /a0006/pqrst1/abcde12 In my output file, I only need to get anything that is between the first and second '/' of each line: exampple:... (6 Replies)
Discussion started by: hemangjani
6 Replies

10. Shell Programming and Scripting

grep & sed question

I'm trying to write a bash script to perform a tedious task, but I have no experience and hardly any knowledge so I've been having a rough time with it. I'm on Mac OS X, and I want a script to do the following: I have a directory that has about 200 sudirectories. In each of these directories,... (1 Reply)
Discussion started by: der Kopf
1 Replies
Login or Register to Ask a Question