Sponsored Content
Top Forums Shell Programming and Scripting Selective printing based on matched record Post 302995667 by dsid on Monday 10th of April 2017 09:39:43 AM
Old 04-10-2017
thank you all for the commands given to me in the earlier posts.

Iv got a couple of other records that I wanna fetch and it is related to the same file so not wanting to open a new thread. Would have pasted this earlier but this requirement never came into the picture.

sample input
Code:
06M5279484366528007 0328 003529         J27300022      MICROSOFT   *MSN
06<1      000000001344392   JPN151-85830 MSBILL.INFO      F
06<A17087454000328651551    MSBILL.INFO  JPN0000000000000000000000000060300
06<BZ20C0WS0L208                              5627
06=0000000000000000001344MCCAW5PIO0328      4816    0
06=51709000100020 09000--
06V4789071000648915 0328 003529R         28600656      MICROSOFT   *XBOXLIVE
06<1      000000001343124ON CANL5N 8L900 MSBILL.INFO     M 2005650000
06<A17087354000328251263    MSBILL.INFO  ON*0000000000000000000000000000000
06<BZ20G0W6Q6PNX                              1928
06#1524V1928 00000000134312400307087366122975VCXS581601    P
06#31Z20G0W6Q6PNX              Z000000       000000001343
70 311200213883             000000007416         13287229
06V4980208991901179 0327 003529         727400138      MICROSOFT   *STORE
06<1      000000013824392   JPN151-85830 MSBILL.INFO     M 2005650000
06<A17086754000327691767    MSBILL.INFO  JPN0000000000000000000000000000000
06<BZ20E0VRXY54Q                              5627
06#1524V5627 00000001382439200467087101247989TLSK481601    G
06#31Z20E0VRXY54Q   1205422440 U000000       000001382400
[70 311160631884             000000001550         69285782

I now want to fetch the related 70 records line from the file. basically, each of the record/s, has a corresponding 70 record line which can be found after a collection of such 06/07 records. For eg, I have highlighted the 70 record line for the first collection of related 06/07 records. This collection of 06/07 records can be 1 or more than 1, but the related 70 records will be directly after these records and will be only 1 in count.

thanks again

Last edited by dsid; 04-10-2017 at 10:42 AM.. Reason: putting in more description
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

selective printing awk

Hi there my file looks like this 1 a b c d e f 2 a b b c d e f f g h e t t 3 a c b d e f 4 a b c i want to print the line which has the fields containing ONLY a b c, in this case the line 4. How can i awk it !!!? Many Thanks in advance! (8 Replies)
Discussion started by: saint2006
8 Replies

2. Shell Programming and Scripting

selective printing of lines

Hi all , i need to grep for a string in a text file and print the string and the 3rd line above it. As always , Thanks. (4 Replies)
Discussion started by: okiedokie
4 Replies

3. Shell Programming and Scripting

sed selective printing

Hi, I have an xml file having serveral smiliar lines as below <INPUT VAR1 ="" DATATYPE ="number(p,s)" VAR2 ="" VAR3 ="3" VAR4="0" VAR5 ="ELEMITEM" VAR6 ="NO" VAR7 ="NOT A KEY" VAR8 ="17" LEVEL ="0" NAME ="UNIX" NULLABLE ="NOTNULL" OCCURS ="0" OFFSET ="19" PHYSICALLENGTH ="15"... (3 Replies)
Discussion started by: dips_ag
3 Replies

4. Shell Programming and Scripting

Awk selective printing

Hi, i need help to print number from different field INPUT: Student1 10 20 Student2 30 40 Student3 50 60 Student4 70 80 Desired Output: 1 20-30 2 40-50 3 60-70 Thank you! (5 Replies)
Discussion started by: saint2006
5 Replies

5. Shell Programming and Scripting

Perl: selective printing of lines

Hi, I have a file with lines like this. 2 7 18 ggcgt anna 2 7 18 hhchc sam 3 7 18 hhdjcc ross 4 7 18 hhcjd jenny 0 8 21 jjdhs sam 3 8 21 kkok bush 2 9 24 kosss BrenhamIf the values of the second column are equal, print only those lines with the least first column value. So in... (5 Replies)
Discussion started by: polsum
5 Replies

6. Shell Programming and Scripting

selective printing

hi all from below text "abcd,SYS_12345,xyz,PQR, ," I want to print only "abcd,SYS,xyz,PQR, ," i.e. taking only first three 3 chars from 2 string of comma separated file thanks (4 Replies)
Discussion started by: JoeColeEPL9
4 Replies

7. Homework & Coursework Questions

[solved]Perl: Printing line numbers to matched strings and hashes.

Florida State University, Tallahassee, FL, USA, Dr. Whalley, COP4342 Unix Tools. This program takes much of my previous assignment but adds the functionality of printing the concatenated line numbers found within the input. Sample input from <> operator: Hello World This is hello a sample... (2 Replies)
Discussion started by: D2K
2 Replies

8. Shell Programming and Scripting

Selective printing

I have the following contents in a file ---- CRITICAL: altered for /usr/bin/bin1 ---- OK: /usr/sbin/bin2 result fine ---- OK: /usr/sbin/bin3 result fine ---- CRITICAL: altered for /usr/bin/bin4 ---- OK: /usr/bin/bin5 result fine ---- OK: /usr/bin/bin6 result fine ---- CRITICAL: altered for... (9 Replies)
Discussion started by: anil510
9 Replies

9. Shell Programming and Scripting

awk Selective printing of fields

Hi Gurus, I have following input file. I tried multiple awk combinations to print selected columns without success. HEX ID Name ver FLRGT Start Time Total Shared End Date ----- -------- --- ------ ------------------------ -------------- -------... (4 Replies)
Discussion started by: shunya
4 Replies

10. UNIX for Beginners Questions & Answers

Continued trouble matching fields in different files and selective field printing ([g]awk)

I apologize in advance, but I continue to have trouble searching for matches between two files and then printing portions of each to output in awk and would very much appreciate some help. I have data as follows: File1 PS012,002 PRQ 0 1 1 17 1 0 -1 3 2 1 2 -1 ... (7 Replies)
Discussion started by: jvoot
7 Replies
PCOMPOS(1)						      General Commands Manual							PCOMPOS(1)

NAME
pcompos - composite RADIANCE pictures. SYNOPSIS
pcompos [ -h ][ -x xres ][ -y yres ][ -b r g b ][ -lh h ][ -la ] [ -t min1 ][ +t max1 ][ -l lab ][ =SS ] pic1 x1 y1 .. or pcompos [ -a ncols ][ -s spacing ][ -o x0 y0 ][ options ] pic1 pic2 .. DESCRIPTION
Pcompos arranges and composites RADIANCE pictures and sends the result to the standard output. Each input picture must be accompanied by an anchor point (unless the -a option is used, see below). This anchor point is the usually position of the picture's left lower corner in the final output, but can be changed for individual pictures with an =SS option, where S is one of '-', '+' or '0', indicating the minimum, maximum or center of the image, respectively. (For example, =+- would indicate the anchor is relative to the right lower corner, and =-0 would indicate the anchor is relative to the center of the left edge.) Negative anchor coordinates result in the input being cropped at the origin. By default, the size of the output picture will be just large enough to encompass all the input files. By specifying a smaller dimension using the -x and -y options, input files can be cropped at the upper boundary. Specifying a larger dimension produces a border. The -b option specifies a background color to appear wherever input files do not cover. The default value is black (0 0 0). The -h option may be used to reduce the information header size, which can grow disproportionately after multiple runs of pcompos and/or pcomb(1). If input files overlap, later pictures will overwrite earlier ones. By default, input files are copied unconditionally within the output boundaries. The -t option specifies a lower threshold intensity under which input pixels will not be copied to the output. The +t option specifies an upper threshold. These options are useful for cutting around irregular boundaries in the input. The -l option can be used to specify a label for a specific picture, which will be given a height determined by the -lh option (default 24 pixels) and placed in the upper left corner of the picture. This label is generated by the program psign(1). The -la option instructs pcompos to label each picture automatically by its name. This is particularly useful in conjunction with the -a option for producing a catalog of images (see example below). The -l option may still be used to override the default label for a picture. The -a option can be used to automatically compute anchor points that place successive pictures next to each other in ncols columns. The ordering will place the first picture in the lower left corner, the next just to the right of it, and so on for ncols pictures. Then, the next row up repeats the pattern until all the input pictures have been added to the output. If the pictures are of different size, pcompos will end up leaving some background areas in the output picture. There will also be an unfinished row at the top if the number of pictures is not evenly divided by ncols. The -s N option will cause each image to be separated by at least N pixels. The -o x0 y0 option specifies a nonzero anchor point for the bottom left image. The standard input can be specified with a hyphen ('-'). A command that produces a RADIANCE picture can be given in place of a file by preceeding it with an exclamation point ('!'). EXAMPLE
To put a copyright label at the bottom of a picture: psign Copyright 1987 | pcompos inp.hdr 0 0 +t .5 - 384 64 > out.hdr To make a catalog of images separated by white 10-pixel borders: pcompos -la -a 4 -s 10 -b 1 1 1 dog*.hdr > alldogs.hdr NOTES
Since there is a limit to the number of open files and processes, large collections of images must be created in stages. Even if the sys- tem limit on open files is large, pcompos places an artificial limit of 1024 on the number of open files and/or processes. AUTHOR
Greg Ward SEE ALSO
getinfo(1), pcomb(1), pfilt(1), psign(1), rpict(1) RADIANCE
12/18/97 PCOMPOS(1)
All times are GMT -4. The time now is 03:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy