awk,cut fields by change field format Post: 302368618

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 CENTOS

xml::xpath::node::element

XPath::Node::Element(3) 				User Contributed Perl Documentation				   XPath::Node::Element(3)

NAME

       Element - an <element>

API

   new ( name, prefix )
       Create a new Element node with name "name" and prefix "prefix". The name be "prefix:local" if prefix is defined. I know that sounds wierd,
       but it works ;-)

   getName
       Returns the name (including "prefix:" if defined) of this element.

   getLocalName
       Returns just the local part of the name (the bit after "prefix:").

   getChildNodes
       Returns the children of this element. In list context returns a list. In scalar context returns an array ref.

   getChildNode ( pos )
       Returns the child at position pos.

   appendChild ( childnode )
       Appends the child node to the list of current child nodes.

   getAttribute ( name )
       Returns the attribute node with key name.

   getAttributes / getAttributeNodes
       Returns the attribute nodes. In list context returns a list. In scalar context returns an array ref.

   appendAttribute ( attrib_node)
       Appends the attribute node to the list of attributes (XML::XPath stores attributes in order).

   getNamespace ( prefix )
       Returns the namespace node by the given prefix

   getNamespaces / getNamespaceNodes
       Returns the namespace nodes. In list context returns a list. In scalar context returns an array ref.

   appendNamespace ( ns_node )
       Appends the namespace node to the list of namespaces.

   getPrefix
       Returns the prefix of this element

   getExpandedName
       Returns the expanded name of this element (not yet implemented right).

   string_value
       For elements, the string_value is the concatenation of all string_values of all text-descendants of the element node in document order.

   toString ( [ norecurse ] )
       Output (and all children) the node to a string. Doesn't process children if the norecurse option is a true value.

perl v5.16.3							    2003-01-26						   XPath::Node::Element(3)

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