pulling the following line from a file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers pulling the following line from a file
# 1  
Old 08-29-2002
pulling the following line from a file

I have return files from a process that has then original input record followed on the next line by a response record..either AA,........... for accepted or EE,.......... for errored.

i.e

11,new,123
AA,accepted
12,exist,443
EE,rejected
13,old,223
AA,accepted

I want to write a small script that will return the row and it's response to a separate file.

I.e. I tell the script I want the records that start 11 and their responses and I get the first two lines above. I can do the pattern matching etc to get the first line - but I am having trouble getting the second line to come back too.
# 2  
Old 08-29-2002
Could you use the -n option of grep to get the line numbers & use awk with {FS=":"} {print $1} to chop them out into a temporary file.

You can then run down the input file again with this file of line numbers & extract the line & the line after each time.

Might take some time to run though.
# 3  
Old 08-29-2002
How about:
sed -n '/^11/{;p;n;p;q;}'

This assumes that want only the first couplet that starts with 11. To get them all, omit "q;".
# 4  
Old 08-29-2002
Thanks guys....

I like the sed option...but I think I found the same in awk.....

awk -F"," ' /^11/ { print ; getline; print } ' my_file

Cheers for your help.
# 5  
Old 08-29-2002
Just to mix things up a little:
If you have GNU grep, you could do this:

grep -A1 "^11" your_file
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Partial file pulling

I am connecting to another server through sftp. I am running one batch script to pull file from another server. sometimes i am receiving partial files. I am using below commands in batch script. ls -ltr new.txt mget new.txt bye The file is of 1 MB only.In most of the cases , i received... (6 Replies)
Discussion started by: srinath01
6 Replies

2. Shell Programming and Scripting

Pulling Data, Then Moving to the Next File

I'm scanning a list of emails- I need to pull 2 pieces of data, then move to the next file: Sender's Email Address Email Date I need these to be outputted into a single column- separated by a ",". Like this: Email1's Address, Email1's Date Stamp Email2's Address, Email2's Date Stamp... (4 Replies)
Discussion started by: sudo
4 Replies

3. UNIX for Dummies Questions & Answers

Pulling Parms from Config File

Hello all, I'm working on a general script for something at work. I'm an up-and-comer backup for a Shell Scripter this company has had for 35 years lol. Anyway, I have a config file I'm trying to pull Variables from as the Config File is used for multiple scripts. Does the below make sense and... (7 Replies)
Discussion started by: phunk
7 Replies

4. Shell Programming and Scripting

pulling different fields from a csv file

Hi, I have a requirment where I need to pull different columns from a .csv file. Here is the sample of the csv file. account,item,flag1,flag2,flag3,flag4,flag5,......feed,tran I will be have a config.txt file which will have the following information. item,flag5,flag10,feed,tran... (2 Replies)
Discussion started by: akdevula
2 Replies

5. Shell Programming and Scripting

Pulling Ip's from log and redirecting to a file

Hi all, I am fairly new to scripting, but I do try and script as much as possible but the more advanced stuff does tend to boggle my mind a bit. I am at a bit of a loss with this one. I get entries in my DNS logs, like the below: I want to extract only the IP address, without the hashes... (5 Replies)
Discussion started by: codenjanod
5 Replies

6. UNIX for Dummies Questions & Answers

Pulling a file from Unix box thru https

Hi I have a file called as MSD.DAT. This file is present at a directory on a server. www.ta.ibhsv.somewhere.com/rahdf/MSD.DAT Now, I want to get this file from this server to my Linux box. I need to write a script that uses https to get the file. Please help how to achieve this. ... (3 Replies)
Discussion started by: infyanurag
3 Replies

7. UNIX for Dummies Questions & Answers

Pulling a file off a backup tape

I have AIX 5.1 This may sound like a really dumb question but I have never done this before. I would like to pull a file off a backup tape and put back on the AIX is this as simple as as doing a mount /dev/rmt1 then the file name that is on the tape /dump/rpt/xxxxxx Do I just copy it... (14 Replies)
Discussion started by: rocker40
14 Replies

8. Shell Programming and Scripting

Pulling data and following lines from file

I saw a few posts close to what i want to do, but they didn't look like they would work exactly.. or I need to think out of the box on this. I have a file that I keep server stats in for my own performance analysis. this file has the output from many commands in it (uptime, vmstats, ps, swap... (2 Replies)
Discussion started by: MizzGail
2 Replies

9. Shell Programming and Scripting

pulling a column from a file in ksh

I would like to pull a column from a file and place it in a variable: The file would look like this: N.Korea gibberish garbage S.Korea gibberish garbage USA gibberish garbage Iraq gibberish garbage Canada gibberish garbage and items in the first... (8 Replies)
Discussion started by: dangral
8 Replies

10. UNIX for Advanced & Expert Users

Pulling out fields from a file

Hi, I have a file that contains 1400 lines similar to the one shown below: NAME=sara, TOWN=southampton, POSTCODE=SO18777, EMAIL=sara@hotmail.com, PASSWORD=asjdflkjds etc etc (note: this is one line). Each line has the same fields, but on each line they are in a different order. Eg. the line... (2 Replies)
Discussion started by: Saz
2 Replies
Login or Register to Ask a Question