how to write a function to get data under specific lines ?

Login or Register to Ask a Question and Join Our Community

how to write a function to get data under specific lines ?

Tags

Top Forums UNIX for Dummies Questions & Answers how to write a function to get data under specific lines ?

11-02-2011

Registered User

81, 0

Join Date: Nov 2011

Last Activity: 10 February 2015, 2:45 PM EST

Posts: 81

Thanks Given: 31

Thanked 0 Times in 0 Posts

how to write a function to get data under specific lines ?

I have a text file called (msgz ) contains data :

Code:

Subscriber 
Data ID = 2 
Customer = 99
Data ID = 4 
Customer = cf99
Data ID = 5 
Customer = c99
Data ID = 11 
Customer = 9n9

Subscriber 
Data ID = 1 
Customer = 9ds9
Data ID = 2 
Customer = 9sad9
Data ID = 3 
Customer = f99
Data ID = 4 
Customer = 9sg9
Data ID = 5 
Customer = 9sg
Data ID = 8 
Customer = 99

And so on for # of subscribers
I want to write a function to get me the customer number under Data ID = 4
Note: number of lines containing data id variable and not in same place 4 every subscriber

Output file >

Code:

Cf994
9sg9
Null      ------------   if its not found ( data id = 4 under each subscriber ) 
…..

Please help I think its impossible

Moderator's Comments:

Mod Comment

Please use code tags when posting data and code samples!

Last edited by vgersh99; 11-02-2011 at 08:17 AM.. Reason: code tags, please!

teefa

View Public Profile for teefa

Find all posts by teefa

11-02-2011

Registered User

28, 5

Join Date: May 2011

Last Activity: 12 December 2016, 12:21 AM EST

Posts: 28

Thanks Given: 4

Thanked 5 Times in 5 Posts

hope it helps..

Quote:

cat <filename> | grep -A 1 "ID = 4" | grep "Customer" | awk '{print $3}' >out.file

This User Gave Thanks to gowtham.varma For This Post:

gowtham.varma

View Public Profile for gowtham.varma

Find all posts by gowtham.varma

11-02-2011

Registered User

833, 187

Join Date: Jul 2008

Last Activity: 9 March 2016, 9:36 AM EST

Posts: 833

Thanks Given: 9

Thanked 187 Times in 177 Posts

Code:

$ nawk -F= '/Data ID = 4/{getline;print $2}' infile

This User Gave Thanks to jayan_jay For This Post:

jayan_jay

View Public Profile for jayan_jay

Find all posts by jayan_jay

11-02-2011

Registered User

81, 0

Join Date: Nov 2011

Last Activity: 10 February 2015, 2:45 PM EST

Posts: 81

Thanks Given: 31

Thanked 0 Times in 0 Posts

@ jayan_jay
thanks alot
please send me to print null if not found under subscriber
2 - if

data id = 4
id = ff
customer= c99

if customer already in all file in the 3rd line or the 2nd after data id
thanks waiting replies

---------- Post updated at 08:07 AM ---------- Previous update was at 08:06 AM ----------

Quote:

Originally Posted by jayan_jay

Code:

$ nawk -F= '/Data ID = 4/{getline;print $2}' infile

Quote:

Originally Posted by gowtham.varma

hope it helps..

thanks alot but i gotta use it in bash
it tells me illegal -A option
-A gets no of lines after it nice work

teefa

View Public Profile for teefa

Find all posts by teefa

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Write out specific data from log to a new file

I got a huge log in zipped files, i need to write out lines by specific data and if the line with the same contains XML message with the same sessionID will be written to the file to. The log structure: 2013-08-16 16:31:06,810 ( 122: rogate) INFO - UId:10453, GId:5422: new...

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!!

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...

4. Shell Programming and Scripting

Print specific lines of a repeated set of data

I have a file that needs 1st line, 2nd line, and 26th line printed from every chunk of data. Each chunk of data contains 26 lines (#line+%line+24 data lines = 26 lines of data repeated). Input file: # This is a data file used for blockA (chunk 1). % 10576 A 10 0 1 04 (data1) 03 (data2)...

5. Homework & Coursework Questions

Shell script calling Perl function, sort and find data, write to new files

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I must write a shell script that calls two external Perl functions--one of which sorts the data in a file, and...

6. Shell Programming and Scripting

how to write a function to get data under spesific lines ? using bash

I have a text file called ( bvhz ) contains data : Subscriber Data ID = 2 Customer = 99 Data ID = 4 Customer = cf99 Data ID = 5 Customer = c99 Data ID = 11 Customer = 9n9 Subscriber Data ID = 1 Customer = 9ds9 Data ID = 2 Customer = 9sad9 Data ID = 3 Customer = f99...

7. 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 ...

8. Shell Programming and Scripting

insert data into specific lines of a CSV

So I work in a 1 to 1 laptop deployment and sometimes we need to mass order parts. The vendor will send us a text file and we have to manually input serial numbers. Well I have a full blown web based inventory system which I can pull serial number reports from. I then have to input the part...

9. Shell Programming and Scripting

[BASH] Using a function to write data to a file

Hello, I've created a shell script, which accepts information using an input from the console. Part of the script will write a file containing this information. My code looks like (for the write) function make_file { cat <<- _EOF_ The contents of my file are here _EOF_ } ...

10. Shell Programming and Scripting

Read Write byte range/chunk of data from specific location in file

I am new to Unix so will really appreciate if someone can guide me on this. What I want to do is: Step1: Read binary file - pick first 2 bytes, convert from hex to decimal. Read the next 3 bytes as well. 2 bytes will specify the number of bytes 'n' that I want to read and write...

Login or Register to Ask a Question