Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need to sort out data

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to sort out data
# 1  
Old 07-25-2014
Need to sort out data
Hello All,

I have one file with multiple lines records like as below.. I need to extract only BFG and corresponding BSG record/line. for evry BFG there is one BSG record is there as mentioned in BOLD [line 1 and line 6] and [line 7 and line 12] so on...


Code:
BFG BR 00001 20140724 000 000 ? ?
BLG UVR QPR 01 380 ? ? 999 0 0 0 ?
BLC F 008 999 ? 0
BLC J 064 999 ? 0
BLC Y 415 999 ? 0
BSG ABCD PQR 0 0 00664 1 1 0 0 1 1 1 0 1 0
BFG BR 00001 20140726 002 000 ? ?
BLG PQV ZRP 01 380 ? ? 999 0 0 0 ?
BLC F 008 999 ? 0
BLC J 064 999 ? 0
BLC Y 415 999 ? 0
BSG LHR KUL 0 0 00664 1 1 0 0 1 1 1 0 1 0
BSB F ? 000 1 000 0004 0999 0000 000 1 0000 0000 0000 ? 0 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
BSB A ? 000 1 000 0004 0999 0000 000 1 0002 0000 0000 ? 0 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
BSB P ? 000 1 000 0000 0999 0000 000 1 0000 0000 0000 ? 1 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

In short i need to extaract only BFG and correponding BSG records from the file by SED ,awk ir any other utility
Moderator's Comments:
Mod Comment Please use CODE tags shen displaying sample input, output, and code segments.
Last edited by Don Cragun; 07-25-2014 at 05:27 AM.. Reason: Add CODE tags.
# 2  
Old 07-25-2014
What have you tried? Also, please use code-tags.
# 3  
Old 07-25-2014
In addition to what clx said, how are we supposed to determine whether or not a BFG record corresponds to a BSG record. I don't see anything in either of the BFG records shown in bold that matches anything in the BSG records shown in bold???
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort data As per first Column

hI I have file A NSU30504 5 6 G 6 NSU3050B T 7 9 J NSU30506 T I 8 9 NSU3050C H J K L Output: NSU3050B T 7 9 J NSU3050C H J K L NSU30504 5 6 G 6 NSU30506 T I 8 9Video tutorial on how to use code tags in The UNIX and Linux Forums. (13 Replies)
Discussion started by: pareshkp
13 Replies

2. UNIX for Dummies Questions & Answers

sort data

Hi, I need to filter the output of a command and display certain data only. How can i do this ? My file contain: $ cat abc.txt <testcase title="AAA_100"> <testcase title="BBB_200"> <testcase title="CCC_300"> <testcase title="DDD"> ... (3 Replies)
Discussion started by: crazydude80
3 Replies

3. Shell Programming and Scripting

Sort Data by Group !

Hello, I have a file and i want to sort by third column and extract the three top lines of each group, it is determined by the second column (144, 89, 55, etc). Could you please help me with the appropiate awk shell script XLY-XLP 144 0.592772 XLY-XLE 144 0.798121 ... (3 Replies)
Discussion started by: csierra
3 Replies

4. Shell Programming and Scripting

Help needed to sort data

Hello All, Today i have been asking lots of question, hope to become good in scripting soon with all the wonderful advices i get. The question is i want to sort data a get uniq string from it. The code i am using to generate the output is:- check_sun() { for i in $SUN_PLATFORM do $ECHO... (0 Replies)
Discussion started by: asirohi
0 Replies

5. Shell Programming and Scripting

Trying to sort data

Im trying to sort all this data. I need to get a list out of the data (websites) and just list them out can anyone point me in the right direction. Im working with dans guardian. 2009.6.10 6:26:50 - 192.168.42.200... (5 Replies)
Discussion started by: darknirvana
5 Replies

6. UNIX for Advanced & Expert Users

sort out the required data

Hi All, I have a file 1.txt which has the duplicate dns entries as shown: Name: 000f9fbc6738.net.in|Addresses: 10.241.66.169, 10.84.2.222,212.241.66.170 Name: 001371e8ed3e.net.in|Addresses: 10.241.65.153, 10.84.1.101 Name: 00e06f5bd42a.net.in|Addresses: 10.72.19.218,... (6 Replies)
Discussion started by: imas
6 Replies

7. Shell Programming and Scripting

Sort complex data

Hi, Can someone here help sorting the following data in numeric order? INPUT: FIRST abc(3) def(13) fgh(1) ijk(6) abc(2) SECOND dfe(10) abc(4) hij(19) tlm(1) hij(1) hub(10) abc(1) fed(3) OTHERS hij(10) mok(4) bub(19) hij(1) abc(2) abc(15) abc(1) hij(3) OUTPUT: FIRST def(13) ijk(6)... (12 Replies)
Discussion started by: need_help
12 Replies

8. Shell Programming and Scripting

sort data in different columns

Hello all: i have list with the following format Id Name Iid Value 0x4440001 customerCode 44077 0x11d2a PrimaryAddress 57.217.41.201 0x129fa ... (15 Replies)
Discussion started by: mogabr
15 Replies

9. Shell Programming and Scripting

Script to sort data

Hi All, I have a .csv file with 3 columns called nLats, nLongs, and fRes. in following format : "nLats","nLongs","fRes" 0,0,-1 0,1,-1 0,2,-1 0,3,-1 0,4,-1 ......... ......... 0,143,-1 nLats increments at nLongs=143 1,0, -1 1,1, -1 .......... .......... 1,143,-1... (1 Reply)
Discussion started by: wizardy_maximus
1 Replies

10. Shell Programming and Scripting

sort data

Hi! I'm trying to sort a file.dat with the sort command. The data contained by file.dat is similar to the data set below: 100.000 99.000 110.000 55.000 113.000 33.000 25.000 9.000 15.000 It is relatively easy to sort the data in ascending or descending order, but the problem is... (11 Replies)
Discussion started by: bjorb
11 Replies
Login or Register to Ask a Question