awk,cut fields by change field format Post: 302368663

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,...

2. UNIX for Advanced & Expert Users

Printing Field with Delimiter in AWK/cut

Hello, I had posted earlier about printing fields using AWK, but now I have a slightly different problem. I have text files in the format: 1*2,3,4,5 and wish to print the first, third, and fifth fields, including the asterisk and commas. In other words, after filtering it should look...

3. UNIX for Advanced & Expert Users

change field 2 date format

from this input WEBELSOLAR,29122009,1:1 WIPRO,15062010,2:3 ZANDUREALT,18012007,1:3 i want output as WEBELSOLAR,20091229,1:1 WIPRO,20100615,2:3 ZANDUREALT,20070118,1:3 basically input is in ddmmyyyy format and i was to convert it to yyyymmdd format

4. Shell Programming and Scripting

AWK : Add Fields of lines with matching field

Dear All, I would like to add values of a field, if the lines match in a certain field. Then I would like to divide the sum though the number of lines that have a matched field. This is the Input: Input: Test1 5 Test1 10 Test2 2 Test2 5 Test2 13 Test3 4 Output: Test1 7.5 Test1 7.5...

5. Shell Programming and Scripting

how to parse with awk (using different fields), then group by a field?

When parsing multiple fields in a file using AWK, how do you group by one of the fields and parse by delimiters? to clarify If a file had tom | 223-2222-4444 , randofield ivan | 123-2422-4444 , random filed ... | and , are the delimiters ... How would you group by the social security...

6. Shell Programming and Scripting

awk - print all fields except for last field

How do I print all the fields of a record except for the $(NF) field?

7. Shell Programming and Scripting

How to Print from nth field to mth fields using awk

Hi, Is there any short method to print from a particular field till another filed using awk? Example File: File1 ==== 1|2|acv|vbc|......|100|342 2|3|afg|nhj|.......|100|346 Expected output: File2 ==== acv|vbc|.....|100 afg|nhj|.....|100

8. Shell Programming and Scripting

how to cut the last field without using awk

i have file as with the below content aaa.bbb.cc.dd aaa.fff.bb yyyyy.rrrrr.ggggg.iii wwww.w.r.ty i want the o/p as below dd bb iii ty but i dont want to use awk. is there any other way to do this ?

9. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk...

10. Shell Programming and Scripting

Insert field between two fields using awk or sed

Hi All, I am trying to insert two columns in the following text. I tried awk but failed to achieve. Highly appreciate your help DATETIME="28-Sep-2013;20:09:08;" CONTROL="AB" echo "Myfile.txt;11671;7824.90;2822.48" The DATETIME will be inserted at the beginning and CONTROL will...

LEARN ABOUT DEBIAN

perl::critic::policy::variables::prohibitlocalvars

Perl::Critic::Policy::Variables::ProhibitLocalVars(3pm) User Contributed Perl DocumentationPerl::Critic::Policy::Variables::ProhibitLocalVars(3pm)

NAME

       Perl::Critic::Policy::Variables::ProhibitLocalVars - Use "my" instead of "local", except when you have to.

AFFILIATION

       This Policy is part of the core Perl::Critic distribution.

DESCRIPTION

       Since Perl 5, there are very few reasons to declare "local" variables.  The most common exceptions are Perl's magical global variables.	If
       you do need to modify one of those global variables, you should localize it first.  You should also use the English module to give those
       variables more meaningful names.

	   local $foo;	 #not ok
	   my $foo;	 #ok

	   use English qw(-no_match_vars);
	   local $INPUT_RECORD_SEPARATOR    #ok
	   local $RS			    #ok
	   local $/;			    #not ok

CONFIGURATION

       This Policy is not configurable except for the standard options.

NOTES

       If an external module uses package variables as its interface, then using "local" is actually a pretty sensible thing to do.  So
       Perl::Critic will not complain if you "local"-ize variables with a fully qualified name such as $Some::Package::foo.  However, if you're in
       a position to dictate the module's interface, I strongly suggest using accessor methods instead.

SEE ALSO

       Perl::Critic::Policy::Variables::ProhibitPunctuationVars

AUTHOR

       Jeffrey Ryan Thalhammer <jeff@imaginative-software.com>

COPYRIGHT

       Copyright (c) 2005-2011 Imaginative Software Systems.  All rights reserved.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  The full text of this license
       can be found in the LICENSE file included with this module.

perl v5.14.2							    2012-06-07		   Perl::Critic::Policy::Variables::ProhibitLocalVars(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

Discussion started by: axo959

2. UNIX for Advanced & Expert Users

Printing Field with Delimiter in AWK/cut

Discussion started by: Jahn

3. UNIX for Advanced & Expert Users

change field 2 date format

Discussion started by: manishma71

4. Shell Programming and Scripting

AWK : Add Fields of lines with matching field

Discussion started by: DerSeb