Extracting text out of specific lines


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extracting text out of specific lines
# 1  
Old 04-16-2009
Extracting text out of specific lines

Hi,
I have a file like

LAHORE 2009-04-16 16:04:19 THU
S5830 FAULT MESSAGE SUPPRESS STATUS
LOC : ASP00
STS : SUPPRESSING CONTINUE
INF : F6201 TRUNK. DATA FAULT REPORT
COMPLETED

LAHORE 2009-04-16 16:04:20 THU
S8400 ISUP SIGNALLING TRACE - NORMAL
ITEM TYPE ASP TRK RTE CALL OPC DPC CIC (PCM/CH)
RTE ALL 007 1980 0600 ICT NAT/H'105f NAT/H'10a4 0604(018/28)
CG_PARTY_NO CD_PARTY_NO ISUP_VERSION
428530559 0427376505F WHITE
---- --- ----------------------------------------------- --------------
MSG DIR DATA TIME
---- --- ----------------------------------------------- --------------
IAM <-- 00 20 01 0a 00 02 0a 08 83 10 40 72 73 56 50 0f [16:04:18.200]
08 01 00 0a 07 83 13 24 58 03 55 09 3d 01 1f 00
REL --> 02 04 02 82 91 1e 02 02 08 00 [16:04:18.920]
RLC <-- 00 [16:04:19.200]
---- --- ----------------------------------------------- --------------
REL_REASON = USER BUSY
COMPLETED

LAHORE 2009-04-16 16:04:20 THU
S8400 ISUP SIGNALLING TRACE - NORMAL
ITEM TYPE ASP TRK RTE CALL OPC DPC CIC (PCM/CH)
RTE ALL 007 2366 0600 ICT NAT/H'105f NAT/H'10a4 0958(029/30)
CG_PARTY_NO CD_PARTY_NO ISUP_VERSION
428711416 0422009120F WHITE
---- --- ----------------------------------------------- --------------
MSG DIR DATA TIME
---- --- ----------------------------------------------- --------------
IAM <-- 00 20 01 0a 00 02 0a 08 81 10 40 22 00 19 02 0f [16:04:17.800]
08 01 00 0a 07 83 13 24 78 11 14 06 3d 01 1f 00
ACM --> 12 14 01 2e 01 00 39 02 2e c0 00 [16:04:18.120]
REL --> 02 00 03 81 81 00 [16:04:19.040]
RLC <-- 00 [16:04:19.400]
---- --- ----------------------------------------------- --------------
REL_REASON = UNALLOC NUMBER
COMPLETED


I want to extract highlighted text and have output like

RTE Call CIC CG_PARTY_NO CD_PARTY_NO Release
600 ICT 0604(018/28) 428530559 0427376505F USER BUSY600 ICT 0958(029/30) 428711416 0422009120F UNALLOC NUMBER

Please help.
# 2  
Old 04-16-2009
Output should be like

600 ICT 0604(018/28) 428530559 0427376505F USER BUSY
600 ICT 0958(029/30) 428711416 0422009120F UNALLOC NUMBER
# 3  
Old 04-16-2009
if your pattern is fixed use this
Code:
awk '/^RTE ALL/{printf $5" "$6" "$NF" "}/WHITE/{printf $1" "$2" "}/^REL_REASON/{printf $3" "$4"\n"}' filename

# 4  
Old 04-16-2009
Thanks. I really appreciate your help.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extracting data between specific lines, multiple times

I need help extracting specific lines in a text file. The file looks like this: POSITION TOTAL-FORCE (eV/Angst) ----------------------------------------------------------------------------------- 1.86126 1.86973 1.86972 ... (14 Replies)
Discussion started by: captainalright
14 Replies

2. UNIX for Advanced & Expert Users

Extracting specific lines from data file

Hello, Is there a quick awk one-liner for this extraction?: file1 49389 text55 52211 text66 file2 59302 text1 49389 text2 85939 text3 52211 text4 13948 text5 Desired output 49389 text2 52211 text4 Thanks!! (5 Replies)
Discussion started by: palex
5 Replies

3. UNIX for Dummies Questions & Answers

Filtering data -extracting specific lines

I have a table to data which one of the columns include string of text from within that, I am searching to include few lines but not others for example I want to to include some combination of word address such as (address.| address? |the address | your address) but not (ip address | email... (17 Replies)
Discussion started by: A-V
17 Replies

4. Shell Programming and Scripting

Extracting Tag along with specific lines

I have this input file: and the desired output is as follows: Desired Output This is a sample taken from a huge file. Basically, the script should take the tag (TDK11..1>) add everything that has bukle=A until it sees the blank lines. Then takes the next tag (TDK2222>) adds everything that... (4 Replies)
Discussion started by: Ernst
4 Replies

5. Shell Programming and Scripting

Extracting specific lines of data from a file and related lines of data based on a grep value range?

Hi, I have one file, say file 1, that has data like below where 19900107 is the date, 19900107 12 144 129 0.7380047 19900108 12 168 129 0.3149017 19900109 12 192 129 3.2766666E-02 ... (3 Replies)
Discussion started by: Wynner
3 Replies

6. Shell Programming and Scripting

extracting specific text from lines

Hello, i've got this output text: and i need it to look something like this: which means that there won't be absolute path of each directory, just it's size and the last word after last '/' in each line, and i also don't need last line '1.7M /tmp' Looks like there is a simple... (5 Replies)
Discussion started by: krater559
5 Replies

7. Shell Programming and Scripting

extracting specific lines from a file

hi all, i searched in unix.com and accquired the following commands for extracting specific lines from a file .. sed -n '16482,16482p' in.sql > out.sql awk 'NR>=10&&NR<=20' in.sql > out.sql.... these commands are working fine if i give the line numbers as such .. but if i pass a... (2 Replies)
Discussion started by: sais
2 Replies

8. Shell Programming and Scripting

Extracting Text Between Two Unique Lines

Hi all! Im trying to extract a portion of text from a file and put it into a new file. I need all the lines between <Placement> and </Placement> including the Placemark lines themselves. Is there a way to extract all instances of these and not just the first one found? I've tried using sed and... (4 Replies)
Discussion started by: Grizzly
4 Replies

9. Shell Programming and Scripting

Extracting specific characters from a text file

I'm extremely new to scripting and linux in general, so please bear with me. The class I'm taking gives virtually no instruction at all, and so I'm trying to learn everything off the web. Anyway, I'm trying to extract characters that follow after a specific pattern ( '<B><FONT FACE="Arial">' ) but... (3 Replies)
Discussion started by: livos23
3 Replies

10. Shell Programming and Scripting

Extracting specific text from a file

Dear All, I have to extract a a few lines from a log file and I know the starting String and end string(WHich is same ). Is there any simplere way using sed - awk. e.g. from the following file -------------------------------------- Some text Date: 21 Oct 2008 Text to be extracted... (8 Replies)
Discussion started by: rahulkav
8 Replies
Login or Register to Ask a Question