Need help with switching field/column values Post: 302165785

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find top N values for field X based on field Y's value

I want to find the top N entries for a certain field based on the values of another field. For example if N=3, we want the 3 best values for each entry: Entry1 ||| 100 Entry1 ||| 95 Entry1 ||| 30 Entry1 ||| 80 Entry1 ||| 50 Entry2 ||| 40 Entry2 ||| 20 Entry2 ||| 10 Entry2 ||| 50...

2. Shell Programming and Scripting

eAdd two fields in a column if their previous field values are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output file as follows If field3 in file1 is same as field3 in the next line then the field4 should add...

3. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the...

4. Shell Programming and Scripting

adding field values if field matches

hi i have file as below , i want to add duplicate records like bell_bb to one record with valuve as 15 ( addition of both ) any oneline awk script to achive this ? header 0 CAMPAIGN_NAME 1 Bell_BB 14 Bell_MONTHLY 803 SOLO_UNBEATABLE 644 Bell_BB 1 Bell_MONTHLY 25 SOLO_UNBEATABLE...

5. Shell Programming and Scripting

counting lines containing two column field values with awk

Hello everybody, I'm trying to count the number of consecutive lines in a text file which have two distinctive column field values. These lines may appear in several line blocks within the file, but I only want a single block to be counted. This was my first approach to tackle the problem (I'm...

6. Shell Programming and Scripting

Transpose field names from column headers to values in one column

Hi All, I'm looking for a script which can transpose field names from column headers to values in one column. for example, the input is: IDa;IDb;IDc;PARAM1;PARAM2;PARAM3; a;b;c;p1val;p2val;p3val; d;e;f;p4val;p5val;p6val; g;h;i;p7val;p8val;p9val; into the output like this: ...

7. UNIX for Dummies Questions & Answers

shift values in one column as header for values in another column

Hi Gurus, I have a tab separated text file with two columns. I would like to make the first column values as headings for the second column values. Ex. >value1 subjects >value2 priorities >value3 requirements ...etc and I want to have a file >value1 subjects >value2 priorities...

8. UNIX for Dummies Questions & Answers

Switching the values in a specific column of a text file

Hi, I have a space de-limited text file. In the fifth column, I would like to switch "1"s with "2"s. How do I go about doing that? Thanks! Sample input: 0 311000259 0 0 1 1 0 311000397 0 0 1 2 0 311000491 0 0 2 1 0 311000516 0 0 2 1 0 311000541 0 0 1 1 0 311000558 0 0 2 1 0 311000566 0...

9. Shell Programming and Scripting

Sum up the column values group by using some field

12-11-2012,PNL,158406 12-11-2012,RISK,4564 12-11-2012,VAR_1D,310101 12-11-2012,VAR_10D,310101 12-11-2012,CB,866 12-11-2012,STR_VAR_1D,298494 12-11-2012,STR_VAR_10D,309623 09-11-2012,PNL,1024106 09-11-2012,RISK,4565 09-11-2012,VAR_1D,317211 09-11-2012,VAR_10D,317211 09-11-2012,CB,985...

10. Shell Programming and Scripting

Sum column values matching other field

this is part of a KT i am going thru. i am writing a script in bash shell, linux where i have 2 columns where 1st signifies the nth hour like 00, 01, 02...23 and 2nd the file size. sample data attached. Desired output is 3 columns which will give the nth hour, number of entries in nth hour and...

LEARN ABOUT DEBIAN

cgi::formbuilder::template::text

CGI::FormBuilder::Template::Text(3pm)			User Contributed Perl Documentation		     CGI::FormBuilder::Template::Text(3pm)

NAME

       CGI::FormBuilder::Template::Text - FormBuilder interface to Text::Template

SYNOPSIS

	   my $form = CGI::FormBuilder->new(
			   fields   => @fields,
			   template => {
			       type => 'Text',
			       template => 'form.tmpl',
			       variable => 'form',
			   }
		      );

DESCRIPTION

       This engine adapts FormBuilder to use "Text::Template". Usage is very similar to Template Toolkit:

	   my $form = CGI::FormBuilder->new(
			   fields => @fields,
			   template => {
			       type => 'Text',		 # use Text::Template
			       template => 'form.tmpl',
			   }
		      );

       The default options passed into "Text::Template->new()" with this calling form are:

	   TYPE   => 'FILE'
	   SOURCE => 'form.tmpl'
	   DELIMITERS => ['<%','%>']

       As these params are passed for you, your template will look very similar to ones used by Template Toolkit and "HTML::Mason" (the
       Text::Template default delimiters are "{" and "}", but using alternative delimiters speeds it up by about 25%, and the "<%" and "%>"
       delimiters are good, familiar-looking alternatives).

       The following methods are provided (usually only used internally):

   engine
       Returns a reference to the "Text::Template" object

   prepare
       Returns a hash of all the fields ready to be rendered.

   render
       Uses the prepared hash and expands the template, returning a string of HTML.

TEMPLATES

	   <% $jshead %>  -  JavaScript to stick in <head>
	   <% $title  %>  -  The <title> of the HTML form
	   <% $start  %>  -  Opening <form> tag and internal fields
	   <% $submit %>  -  The submit button(s)
	   <% $reset  %>  -  The reset button
	   <% $end    %>  -  Closing </form> tag
	   <% $fields %>  -  List of fields
	   <% $field  %>  -  Hash of fields (for lookup by name)

       Note that you refer to variables with a preceding "$", just like in Perl.  Like Template Toolkit, you can specify a variable to place
       fields under:

	   my $form = CGI::FormBuilder->new(
	       fields => @fields,
	       template => {
		    type => 'Text',
		    template => 'form.tmpl',
		    variable => 'form'
	       },
	   );

       Unlike Template Toolkit, though, these will not be placed in OO-style, dot-separated vars. Instead, a hash will be created which you then
       reference:

	   <% $form{jshead} %>
	   <% $form{start}  %>
	   etc.

       And field data is in a hash-of-hashrefs format:

	   For a field named...  The field data is in...
	   --------------------  -----------------------
	   job			 <% $form{field}{job}	%]
	   size 		 <% $form{field}{size}	%]
	   email		 <% $form{field}{email} %]

       Since "Text::Template" looks so much like Perl, you can access individual elements and create variables like so:

	   <%
	       my $myfield = $form{field}{email};
	       $myfield->{label};      # text label
	       $myfield->{field};      # field input tag
	       $myfield->{value};      # first value
	       $myfield->{values};     # list of all values
	       $myfield->{options};    # list of all options
	       $myfield->{required};   # required flag
	       $myfield->{invalid};    # invalid flag
	       $myfield->{error};      # error string if invalid
	   %>

	   <%
	       for my $field (@{$form{fields}}) {
		   $OUT .= "<tr>
<td>" . $field->{label} . "</td> <td>"
					. $field->{field} . "</td>
<tr>";
	       }
	   %>

       In addition, when using the engine option, you supply an existing Text::Template object or a hash of parameters to be passed to "new()".
       For example, you can ask for different delimiters yourself:

	   my $form = CGI::FormBuilder->new(
	       fields => @fields,
	       template => {
		    type => 'Text',
		    template => 'form.tmpl',
		    variable => 'form',
		    engine   => {
		       DELIMITERS => [ '[@--', '--@]' ],
		    },
		    data => {
			 version => 1.23,
			 author  => 'Fred Smith',
		    },
	       },
	   );

       If you pass a hash of parameters, you can override the "TYPE" and "SOURCE" parameters, as well as any other "Text::Template" options. For
       example, you can pass in a string template with "TYPE => STRING" instead of loading it from a file. You must specify both "TYPE" and
       "SOURCE" if doing so.  The good news is this is trivial:

	   my $form = CGI::FormBuilder->new(
	       fields => @fields,
	       template => {
		    type => 'Text',
		    variable => 'form',
		    engine   => {
			 TYPE => 'STRING',
			 SOURCE => $string,
			 DELIMITERS => [ '[@--', '--@]' ],
		    },
		    data => {
			 version => 1.23,
			 author  => 'Fred Smith',
		    },
	       },
	   );

       If you get the crazy idea to let users of your application pick the template file (strongly discouraged) and you're getting errors, look at
       the "Text::Template" documentation for the "UNTAINT" feature.

       Also, note that "Text::Template"'s "PREPEND => 'use strict;'" option is not recommended due to the dynamic nature for "FormBuilder".  If
       you use it, then you'll have to declare each variable that "FormBuilder" puts into your template with "use vars qw($jshead' ... etc);"

       If you're really stuck on this, though, a workaround is to say:

	   PREPEND => 'use strict; use vars qw(%form);'

       and then set the option "variable => 'form'". That way you can have strict Perl without too much hassle, except that your code might be
       exhausting to look at :-).  Things like $form{field}{your_field_name}{field} end up being all over the place, instead of the nicer short
       forms.

       Finally, when you use the "data" template option, the keys you specify will be available to the template as regular variables. In the above
       example, these would be "<% $version %>" and "<% $author %>". And complex datatypes are easy:

	   data => {
		   anArray => [ 1, 2, 3 ],
		   aHash => { orange => 'tangy', chocolate => 'sweet' },
	   }

       This becomes the following in your template:

	   <%
	       @anArray;    # you can use $myArray[1] etc.
	       %aHash;	    # you can use $myHash{chocolate} etc.
	   %>

       For more information, please consult the "Text::Template" documentation.

SEE ALSO

       CGI::FormBuilder, CGI::FormBuilder::Template, Text::Template

REVISION

       $Id: Text.pm 100 2007-03-02 18:13:13Z nwiger $

AUTHOR

       Copyright (c) Nate Wiger <http://nateware.com>. All Rights Reserved.

       Text::Template support is due to huge contributions by Jonathan Buhacoff.  Thanks man.

       This module is free software; you may copy this under the terms of the GNU General Public License, or the Artistic License, copies of which
       should have accompanied your Perl kit.

perl v5.14.2							    2011-09-16				     CGI::FormBuilder::Template::Text(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find top N values for field X based on field Y's value

Discussion started by: FrancoisCN

2. Shell Programming and Scripting

eAdd two fields in a column if their previous field values are same

Discussion started by: yerruhari

3. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Discussion started by: amigarus

4. Shell Programming and Scripting

adding field values if field matches

Discussion started by: raghavendra.cse