awk to print lines based on string match on another line and condition Post: 302428763

Sponsored Content

Top Forums Shell Programming and Scripting awk to print lines based on string match on another line and condition Post 302428763 by rowie718 on Friday 11th of June 2010 01:07:43 AM

06-11-2010

Registered User

awk to print lines based on string match on another line and condition

Hi folks,

I have a text file that I need to parse, and I cant figure it out. The source is a report breaking down softwares from various companies with some basic info about them (see source snippet below). Ultimately what I want is an excel sheet with only Adobe and Microsoft software name and then its version number tab or comma delimited. Id like to use awk as Im trying to get more familiar with it, with a search string that says something like /^ *Location:.*Adobe/ to help determine which entries are applicable, and then print 4 and 6 lines before that. I cant figure out how to do that, and then on top of it, the main catch is that some entries will satisfy the string match, but wont have the Version on the appropriate line (could be 3 instead of 4 lines before matched line), so there has to be a check like "if NR-3 or NR-4 starts with /^ ?Version/ print that and then whatever is 2 lines before that." Ive tried a ton of code snippets and approaches, but nothing even came close to working, so I havent included any.

Here is a bit of the source. Notice the 3rd entry would be an example of something that satisfies the string match but has Version and Software name 3 and 5 lines before instead of 4 and 6. I wouldnt want the 4th entry included at all. Thanks so much for any help!

Code:

    Bridge CS3:

      Version: 2.1.1.9
      Last Modified: 11/6/08 10:27 AM
      Kind: Universal
      Get Info String: 2.1.1.9 (124992), Copyright 2003-2007, Adobe Systems, Inc.
      Location: /Applications/Adobe Bridge CS3/Bridge CS3.app

    Adobe Bridge CS4:

      Version: 3.0.0.464
      Last Modified: 9/15/09 5:34 PM
      Kind: Universal
      Get Info String: 3.0.0.464 (144651), Copyright 2003-2007, Adobe Systems, Inc.
      Location: /Applications/Adobe Bridge CS4/Adobe Bridge CS4.app

    Device Central:

      Version: 1.1.0
      Last Modified: 11/6/08 10:53 AM
      Kind: Universal
      Location: /Applications/Adobe Device Central CS3/Device Central.app

    Chess:

      Version: 2.4.1
      Last Modified: 9/16/09 10:30 AM
      Kind: Universal
      Get Info String: 2.4.1, Copyright 2003-2008 Apple Inc.
      Location: /Applications/Chess.app

The final output should look like this, so I can import it into excel:

Code:

Bridge CS3,2.1.1.9,Adobe Bridge CS4,3.0.0.464,Device Central,1.1.0

Last edited by Franklin52; 06-11-2010 at 06:21 AM.. Reason: Please use code tags!

rowie718

View Public Profile for rowie718

Find all posts by rowie718

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

searching and storing unknown number of lines based on the string with a condition

Dear friends, Please help me to resolve the problem below, I have a file with following content: date of file creation : 12 feb 2007 ==================== = name : suresh = city :mumbai #this is a blank line = date : 1st Nov 2005 ==================== few lines of some text this...

2. Shell Programming and Scripting

awk find a string, print the line 2 lines below it

I am parsing a nagios config, searching for a string, and then printing the line 2 lines later (the "members" string). Here's the data: define hostgroup{ hostgroup_name chat-dev alias chat-dev members thisisahostname } define hostgroup{ ...

3. Shell Programming and Scripting

Based on column in file1, find match in file2 and print matching lines

file1: file2: I need to find matches for any lines in file1 that appear in file2. Desired output is '>' plus the file1 term, followed by the line after the match in file2 (so the title is a little misleading): This is honestly beyond what I can do without spending the whole night on it, so I'm...

4. Shell Programming and Scripting

awk print pattern match line and following lines

Data: Pattern Data Data Data Data Data Data Data Data Data ... With awk, how do I print the pattern matching line, then the subsequent lines following the pattern matching line. Varying number of lines following the pattern matching line.

5. Shell Programming and Scripting

Print certain lines based on condition

Hi All, I have following listing Filesystem GB blocks Free Used Iused Iused Mounted on /dev/hd2 4.00 0.31 93 63080 43 /usr Filesystem GB blocks Free Used Iused Iused Mounted on Filesystem GB blocks Free Used Iused Iused...

6. Shell Programming and Scripting

Print lines based on line number and specified condition

Hi, I have a file like below. 1,2,3,4,5,6,7,8,9I would like to print or copied to a file based of line count in perl If I gave a condition 1 to 3 then it should iterate over above file and print 1 to 3 and then again 1 to 3 etc. output should be 1,2,3 4,5,6 7,8,9

7. Shell Programming and Scripting

Need to print the next word from the same line based on grep string condtion match.

I need to fetch particular string from log file based on grep condition match. Actual requirement is need to print the next word from the same line based on grep string condtion match. File :Java.lanag.xyz......File copied completed : abc.txt Ouput :abc.txt I have used below...

8. UNIX for Dummies Questions & Answers

awk - (URGENT!) Print lines sort and move lines if match found

URGENT HELP IS NEEDED!! I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but - Currently, script is not printing lines to File3.txt in order. - Also the matching lines are not moving out of File1.txt ...

9. Shell Programming and Scripting

awk if condition match and print all

Hi, I am trying to do something like this ... I use awk to match a pattern, and then print out all col. My code is : awk '{if ($1 ==300) print $1,$2-'$sbin7',$3}' tmp.txt output= 300 2 whereby sbin7=2, The thing is, I want to print all col and row, not just the matched line/row only, but...

10. Shell Programming and Scripting

awk if condition match and fix print decimal place

Hi All, I have problem in the middle of implementing to users, whereby the complaint is all about the decimal place which is too long. I need two decimal places only, but the outcome from command is always fixed to 6. See the sample : before: Sort Total Site Sort SortName Parts ...

LEARN ABOUT MOJAVE

cupstestdsc

cupstestdsc(1)							    Apple Inc.							    cupstestdsc(1)

NAME

       cupstestdsc - test conformance of postscript files (deprecated)

SYNOPSIS

       cupstestdsc [ -h ] filename.ps [ ...  filenameN.ps ]
       cupstestdsc [ -h ] -

DESCRIPTION

       cupstestdsc  tests the conformance of PostScript files to the Adobe PostScript Language Document Structuring Conventions Specification ver-
       sion 3.0.  The results of testing and any other output are sent to the standard output.	The second form of the	command  reads	PostScript
       from the standard input.

NOTES

       This program is deprecated and will be removed in a future release of CUPS.

       cupstestdsc  only  validates the DSC comments in a PostScript file and does not attempt to validate the PostScript code itself.	Developers
       must ensure that the PostScript they generate follows the rules defined by Adobe.  Specifically, all pages  must  be  independent  of  each
       other,  code outside page descriptions may not affect the graphics state (current font, color, transform matrix, etc.), and device-specific
       commands such as setpagedevice should not be used.

SEE ALSO

       CUPS Online Help (http://localhost:631/help), Adobe PostScript Language Document Structuring Conventions Specification, Version 3.0.

COPYRIGHT

       Copyright (C) 2007-2017 by Apple Inc.

11 June 2014							       CUPS							    cupstestdsc(1)