awk to search similar strings and add their values Post: 302589610

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk search for Quoted strings (')

Hi All, I have files: 1. abc.sql 'This is a sample file for testing' This does not have quotations this also does not have quotations. and this 'has quotations'. here I need to list the hard coded strings 'This is a sample file for testing' and 'has quotations'. So i have...

2. Shell Programming and Scripting

Varying number of awk search strings

I've created an awk script that handles a varying number of search strings handed to it as command line parameters ($1 $2 etc). There may be 1, or 2 or 3 or more. A simplified version of the script is: awk -v TYP="$1 $2 $3 $4 $5 $6" ' BEGIN { CTYP = split (TYP,TYPP," ") } ...

3. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

I have read another post about this issue and am wondering how to adapt it to my own, much simpler, issue. I have a file of user IDs like so: 333333 321321 546465 ...etc I need to take each number and use it to print records wherein the 5th field matches the user ID pulled from the...

4. Shell Programming and Scripting

Using Awk to Search Two Strings on One Line

If i wanted to search for two strings that are on lines in the log, how do I do it? The following code searches for just one string that is one one line. awk '/^/ {split($2,s,",");a=$1 FS s} /failure agaf@fafa/ {b=a} END{print b}' urfile What if I wanted to search for "failure agaf@fafa"...

5. Shell Programming and Scripting

awk how to search strings within a file from two different lines

Hi, i would really appreciate any help anyone can give with the following info. Thanks in advance. I need to run a search on a file that contains thousands of trades, each trade is added into the file in blocks of 25 lines. i know the search has to take place between a time stamp specified...

6. Shell Programming and Scripting

awk search an output string between two strings

I would like to search for strings stored in searchstringfile.txt in inputfiles. searchstringfile.txt J./F. Gls. Wal F. Towerinput1.txt What is needed is J./F. 12 var Gls. Wal 16 interp. Tower 12 input2.txt Awk shall search for F. 16 pt. J./F. 22 output.txt input1.txt J./F. = 12 var...

7. Shell Programming and Scripting

awk to search similar strings and arrange in a specified pattern

Hi, I'm running a DB query which returns names of people and writes it in a text file as shown below: Carey, Jim; Cena, John Cena, John Sen, Tim; Burt, Terrence Lock, Jessey; Carey, Jim Norris, Chuck; Lee, Bruce Rock, Dwayne; Lee, Bruce I want to use awk and get all the names...

8. Shell Programming and Scripting

Using awk to match strings and outputing their corresponding values

Hi I will appreciate it if you can help me out. I have a file that contains this data System Load: 3244 card: 1903 CPU: 6% card: 1904 CPU: 6% card: 1905 CPU: 28% card: 1906 CPU: 28% card: 1907 CPU: 36% card: 1908 CPU: 37% I need to manipulate and output this as system_load:3244...

9. Shell Programming and Scripting

To search for a particular tag in xml and collate all similar tag values and display them count

I want to basically do the below thing. Suppose there is a tag called object1. I want to display an output for all similar tag values under heading of Object 1 and the count of the xmls. Please help File: <xml><object1>house</object1><object2>child</object2>...

10. Shell Programming and Scripting

Add values of similar patterns with awk

so my output is this: session_closed=157 session_opened=151 session_closed=18 session_opened=17 there are two patterns here, but with different values. the two patterns are "session_opened" and "session_closed". i expect there will be many more other patterns. what i want to do is...

LEARN ABOUT DEBIAN

cgi::xmlform

XMLForm(3pm)						User Contributed Perl Documentation					      XMLForm(3pm)

NAME

       CGI::XMLForm - Extension of CGI.pm which reads/generates formated XML.

       NB: This is a subclass of CGI.pm, so can be used in it's place.

SYNOPSIS

	 use CGI::XMLForm;

	 my $cgi = new CGI::XMLForm;

	 if ($cgi->param) {
	       print $cgi->header, $cgi->pre($cgi->escapeHTML($cgi->toXML));
	 }
	 else {
	       open(FILE, "test.xml") or die "Can't open: $!";
	       my @queries = ('/a', '/a/b*', '/a/b/c*', /a/d');
	   print $cgi->header,
		     $cgi->pre($cgi->escapeHTML(
			 join "
", $cgi->readXML(*FILE, @queries)));
	 }

DESCRIPTION

       This module can either create form field values from XML based on XQL/XSL style queries (full XQL is _not_ supported - this module is
       designed for speed), or it can create XML from form values. There are 2 key functions: toXML and readXML.

       toXML

       The module takes form fields given in a specialised format, and outputs them to XML based on that format. The idea is that you can create
       forms that define the resulting XML at the back end.

       The format for the form elements is:

	 <input name="/body/p/ul/li">

       which creates the following XML:

	 <body>
	   <p>
		 <ul>
		   <li>Entered Value</li>
		 </ul>
	       </p>
	 </body>

       It's the user's responsibility to design appropriate forms to make use of this module. Details of how come below...

       Also supported are attribute form items, that allow creation of element attributes. The syntax for this is:

	 <input name="/body/p[@id='mypara' and @onClick='someFunc()']/@class">

       Which creates the following XML:

	 <body>
	   <p id="mypara" onClick="someFunc()" class="Entered Value"></p>
	 </body>

       Also possible are relative paths. So the following form elements:

	 <input type="hidden" name="/table/tr">
	 <input type="text" name="td">
	 <input type="text" name="td">
	 <input type="text" name="../tr/td">

       Will create the following XML:

	 <table>
	   <tr>
		 <td>value1</td>
		 <td>value2</td>
	       </tr>
	       <tr>
		 <td>value3</td>
	       </tr>
	 </table>

SYNTAX

       The following is a brief syntax guideline

       Full paths start with a "/" :

	 "/table/tr/td"

       Relative paths start with either ".." or just a tag name.

	 "../tr/td"
	 "td"

       Relative paths go at the level above the previous path, unless the previous path was also a relative path, in which case it goes at the
       same level. This seems confusing at first (you might expect it to always go at the level above the previous element), but it makes your
       form easier to design. Take the following example: You have a timesheet (see the example supplied in the archive) that has monday,tues-
       day,etc. Our form can look like this:

	 <input type="text" name="/timesheet/projects/project/@Name">
	 <input type="text" name="monday">
	 <input type="text" name="tuesday">
	 ...

       Rather than:

	 <input type="text" name="/timesheet/projects/project/@Name">
	 <input type="text" name="monday">
	 <input type="text" name="../tuesday">
	 <input type="text" name="../wednesday">
	 ...

       If unsure I recommend using full paths, relative paths are great for repeating groups of data, but weak for heavily structured data. Pic-
       ture the following paths:

	 /timesheet/employee/name/forename
	 ../surname
	 title
	 ../department

       This actually creates the following XML:

	 <timesheet>
	   <employee>
		 <name>
		   <forename>val1</forname>
		       <surname>val2</surname>
		       <title>val3></title>
		 </name>
		 <department>val4</department>
	       </employee>
	 </timesheet>

       Confusing eh? Far better to say:

	 /timesheet/employee/name/forename
	 /timesheet/employee/name/surname
	 /timesheet/employee/name/title
	 /timesheet/employee/department

       Or alternatively, better still:

	 /timesheet/employee/name (Make hidden and no value)
	 forename
	 surname
	 title
	 ../department

       Attributes go in square brackets. Attribute names are preceded with an "@", and attribute values follow an "=" sign and are enclosed in
       quotes. Multiple attributes are separated with " and ".

	 /table[@bgcolor="blue" and @width="100%"]/tr/td

       If setting an attribute, it follows after the tag that it is associated with, after a "/" and it's name is preceded with an "@".

	 /table/@bgcolor

       readXML

       readXML takes either a file handle or text as the first parameter and a list of queries following that. The XML is searched for the queries
       and it returns a list of tuples that are the query and the match.

       It's easier to demonstrate this with an example. Given the following XML:

	 <a>Foo
	   <b>Bar
		 <c>Fred</c>
		 <c>Blogs</c>
	       </b>
	       <b>Red
		 <c>Barbara</c>
		 <c>Cartland</c>
	       </b>
	       <d>Food</d>
	 </a>

       And the following queries:

	 /a
	 /a/b*
	 c*
	 /a/d

       it returns the following result as a list:

	 /a
	 Foo
	 /a/b
	 Bar
	 c
	 Fred
	 c
	 Blogs
	 /a/b
	 Red
	 c
	 Barbara
	 c
	 Cartland
	 /a/d
	 Food

       (NB: This is slightly incorrect - for /a and /a/b it will return "Foo
    " and "Bar
      " respectively).

       The queries support relative paths like toXML (including parent paths), and they also support wildcards using ".*" or ".*?" (preferably
       ".*?" as it's probably a better match). If a wildcard is specified the results will have the actual value substituted with the wildcard.
       Wildcards are a bit experimental, so be careful ;-)

       Caveats

       There are a few caveats to using this module:

AUTHOR

	   Matt Sergeant msergeant@ndirect.co.uk, sergeant@geocities.com

	   Based on an original concept, and discussions with, Jonathan Eisenzopf.  Thanks to the Perl-XML mailing list for suggesting the XSL
	   syntax.

	   Special thanks to Francois Belanger (francois@sitepak.com) for his mentoring and help with the syntax design.

SEE ALSO

       CGI(1), CGI::XML

perl v5.8.8							    2005-01-18							      XMLForm(3pm)