Segregating the data with awk Post: 302534837

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

data format from (4.56 0.7) -> 4.6(7) awk?!

Hi, I have to manipulate a data file which say reads like this {$index $value $error_on_value} aa 4.56 0.7 bb 123.456 0.00987 cc 987654 321 . . in easily human readable format of type aa 4.6(7) bb 123.456(1) cc 9.877(3)e+05 value rounded to 4.6 with error of 0.7 on the last...

2. Shell Programming and Scripting

Reformatting Data in AWK

Dear AWK Users, I have a data set that is so large (Gigabytes) that it cannot be opened in the vi editor in its entirety. But I can manipulate the entire thing in AWK. It is formatted in a regular manner such that it has the variable descriptions or listings preceeding the variables. The latter...

3. Shell Programming and Scripting

Computing data in awk

Hello, I am a newbie in programing. I want to compute the following in awk. I have the following data file: ID Value1 Value2 Value3 sade 0.21 0.45 23 foly 0.31 0.34 43 jude 0.40 0.11 63 jude 0.53 0.32 34 sade 0.67 0.49 66 foly 0.30 0.20 56 I want to take an ID “sade” , then take its...

4. Shell Programming and Scripting

AWK help. how to compare a variable with a data array in AWK?

Hi all, i have a data array as follows. array=ertfgj2345 array=456ttygkd . . . array=errdjt3235 so number or elements in the array can varies depending on how big the data input is. now i have a variable, and it is $1 (there are $2, $3 and so on, i am only interested in $1). ...

5. Shell Programming and Scripting

Help with parsing data with awk , eliminating unwanted data

Experts , Below is the data: --- Physical volumes --- PV Name /dev/dsk/c1t2d0 VG Name /dev/vg00 PV Status available Allocatable yes VGDA 2 Cur LV 8 PE Size (Mbytes) 8 Total PE 4350 Free PE 2036 Allocated PE 2314 Stale PE 0 IO Timeout (Seconds) default --- Physical volumes ---...

6. Shell Programming and Scripting

Data processing using awk

Hello, I have some bitrate data in a csv which is in an odd format and is difficult to process in Excel when I have thousands of rows. Therefore, I was thinking of doing this in bash and using awk as the primary application except that due to its complication, I'm a little stuck. ...

7. Shell Programming and Scripting

Grepping data using awk

Hello, I have a data in file 1 2000000024776 2000000026979 2000000033355 2000000036309 2000000041291 2000000042679 2000000067221 and in file 2 its like this 2000000024776 16 2000000026979 16 2000000033355 16

8. Shell Programming and Scripting

awk --> math-operation in data-record and joining with second file data

Hi! I have a pretty complex job - at least for me! i have two csv-files with meassurement-data: fileA ......

9. Shell Programming and Scripting

Format Data - awk ..

/clusters/cluster-1/exports/storage-views/M1_CRE03_SV: Name Value ------------------------ --------------------------------------------------------------------------------------------------- caw-enabled true controller-tag - initiators ...

10. Linux

Pivoting data with awk

Hi Friends, I need to pivot data . Below is my source data Source Data PK PRTY_KEY_ID PRTY_SUB_KEY_ID KEY_COL_VAL_TX MTCH_CNFDNCE_RATE 007824822 428844791 1 #Jemmy#Pom#600 Kearsarge Way 100 007824822 429283974 1 #Jemmy#Pom#120 Broadway 100 007824822 429739103 1 #Jemmy#Pom#600 Keae Way#757...

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)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

data format from (4.56 0.7) -> 4.6(7) awk?!

Discussion started by: ahan

2. Shell Programming and Scripting

Reformatting Data in AWK

Discussion started by: sda_rr

3. Shell Programming and Scripting

Computing data in awk

Discussion started by: ubeejani

4. Shell Programming and Scripting

AWK help. how to compare a variable with a data array in AWK?

Discussion started by: usustarr