Sponsored Content
Top Forums Shell Programming and Scripting Sort a the file & refine data column & row format Post 302537696 by bartus11 on Saturday 9th of July 2011 11:02:47 AM
Old 07-09-2011
Try:
Code:
awk -F"[ :]" -vRS= 'BEGIN{print "field1 field2 field3 field4"}{gsub("\"","");gsub("\n"," ");print $2,$5,$7,$9}' file

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Search for & edit rows & columns in data file and pipe

Dear unix gurus, I have a data file with header information about a subject and also 3 columns of n rows of data on various items he owns. The data file looks something like this: adam peter blah blah blah blah blah blah car 01 30 200 02 31 400 03 57 121 .. .. .. .. .. .. n y... (8 Replies)
Discussion started by: tintin72
8 Replies

2. Shell Programming and Scripting

Format - Inventory Row data into Column - Awk - Nawk

Hi All, I have the following file that has computer data for various pcs in my network... Snap of the file is as follows ******************************************************************************* Serial 123456 Computer IP Address lo0:... (1 Reply)
Discussion started by: aavam
1 Replies

3. Shell Programming and Scripting

sort the org_no & member_type column ascending

I have a FILE1.DAT with the following information 21111111110001343 000001004OLF-AA029100020091112 21111111110000060 000001004ODL-CH001000020091112 24444444440001416 000001045OLF-AA011800020091112 23333333330001695 000001039OLF-AA030600020091112 23333333330000111... (5 Replies)
Discussion started by: new2ksh
5 Replies

4. Shell Programming and Scripting

replace & with & xml file

Hello All I have a xml file with many sets of records like this <mytag>mydata</mytag> <tag2>data&</tag2> also same file can be like this <mytag>mydata</mytag> <tag2>data&</tag2> <tag3>data2&amp;data3</tag3> Now i can grep & and replace with &amp; for whole file but it will replace all... (4 Replies)
Discussion started by: lokaish23
4 Replies

5. UNIX for Dummies Questions & Answers

How to remove duplicated based on longest row & largest value in a column

Hii i have a file with data as shown below. Here i need to remove duplicates of the rows in such a way that it just checks for 2,3,4,5 column for duplicates.When deleting duplicates,retain largest row i.e with many columns with values should be selected.Then it must remove duplicates such that by... (11 Replies)
Discussion started by: reva
11 Replies

6. Shell Programming and Scripting

awk/sed to search & replace data in first column

Hi All, I need help in manipulating the data in first column in a file. The sample data looks like below, Mon Jul 18 00:32:52 EDT 2011,NULL,UAT Jul 19 2011,NULL,UAT 1] All field in the file are separated by "," 2] File is having weekly data extracted from database 3] For eg.... (8 Replies)
Discussion started by: gr8_usk
8 Replies

7. Shell Programming and Scripting

Sort data from column to row

Hi, I need somebody's help with sorting data with awk. I've got a file: 10 aaa 4584 12 bbb 6138 20 ccc 4417 21 ddd 7796 10 eee 7484 12 fff ... (5 Replies)
Discussion started by: killerbee
5 Replies

8. Shell Programming and Scripting

awk - script help: column to row format of data allignment?

Experts Good day, I have the following data, file1 BRAAGRP1 A2X B2X C2X D2X BRBGRP12 A3X B3X Z10 D09 BRC1GRP2 LO01 (4 Replies)
Discussion started by: rveri
4 Replies

9. Shell Programming and Scripting

File Move & Sort by Name - Kick out Bad File Names & More

I have a dilemma, we have users who are copying files to "directory 1." These images have file names which include the year it was taken. I need to put together a script to do the following: Examine the file naming convention, ensuring it's the proper format (e.g. test-1983_filename-123.tif)... (8 Replies)
Discussion started by: Nvizn
8 Replies

10. UNIX for Beginners Questions & Answers

Shell command to transpose Row & Column

Hi all, need a help with getting a one line command to do the following. i have an input file with rows of data containing credits for each office, the output should be one row for each office with all the credits in rows for that office, if its not there then it should say N/A. the credits are... (10 Replies)
Discussion started by: tech_frk
10 Replies
EasyOBJ(3pm)						User Contributed Perl Documentation					      EasyOBJ(3pm)

NAME
XML::EasyOBJ - Easy XML object navigation VERSION
Version 1.12 SYNOPSIS
# open exisiting file my $doc = new XML::EasyOBJ('my_xml_document.xml'); my $doc = new XML::EasyOBJ(-type => 'file', -param => 'my_xml_document.xml'); # create object from XML string my $doc = new XML::EasyOBJ(-type => 'string', -param => $xml_source); # create new file my $doc = new XML::EasyOBJ(-type => 'new', -param => 'root_tag'); # read from document my $text = $doc->some_element($index)->getString; my $attr = $doc->some_element($index)->getAttr('foo'); my $element = $doc->some_element($index); my @elements = $doc->some_element; # first "some_element" element my $elements = $doc->some_element; # list of "some_element" elements my @elements = $doc->some_element; # write to document $doc->an_element->setString('some string') $doc->an_element->addString('some string') $doc->an_element->setAttr('attrname', 'val') $doc->an_element->setAttr('attr1' => 'val', 'attr2' => 'val2') # access elements with non-name chars and the underlying DOM my $element = $doc->getElement('foo-bar')->getElement('bar-none'); my $dom = $doc->foobar->getDomObj; # get elements without specifying the element name my @elements = $doc->getElement(); my $sixth_element = $doc->getElement('', 5); # remove elements/attrs $doc->remElement('tagname', $index); $doc->tag_name->remAttr($attr); # remap builtin methods $doc->remapMethod('getString', 's'); my $text = $doc->some_element->s; DESCRIPTION
I wrote XML::EasyOBJ a couple of years ago because it seemed to me that the DOM wasn't very "perlish" and the DOM is difficult for us mere mortals that don't use it on a regular basis. As I only need to process XML on an occasionally I wanted an easy way to do what I needed to do without having to refer back to DOM documentation each time. A quick fact list about XML::EasyOBJ: * Runs on top of XML::DOM * Allows access to the DOM as needed * Simple routines to reading and writing elements/attributes REQUIREMENTS
XML::EasyOBJ uses XML::DOM. XML::DOM is available from CPAN (www.cpan.org). METHODS
Below is a description of the methods avialable. new You can create a new object from an XML file, a string of XML, or a new document. The constructor takes a set of key value pairs as follows: -type The type is either "file", "string" or "new". "file" will create the object from a file source, "string" will create the object from a string of XML code, and "new" will create a new document object. -param This value depends on the -type that is passed to the constructor. If the -type is "file" this will be the filename to open and parse. If -type is "string", this is a string of XML code. If -type is "new", this is the name of the root element. Creating an object from an XML file: my $doc = new XML::EasyOBJ(-type => 'file', -param => 'my_xml_document.xml'); Creating an object from a string containing the XML source: my $doc = new XML::EasyOBJ(-type => 'string', -param => $xml_source); Creating a new XML document by passing the root tag name: my $doc = new XML::EasyOBJ(-type => 'new', -param => 'root_tag'); -expref Passing a value of 1 will force the expansion of references when grabbing string data from the XML file. The default value is 0, not to expand references. Obtionally you may also pass the filename to open as the first argument instead of passing the -type and -param parameters. This is backwards compatable with early version of XML::EasyOBJ which did not handle -type and -param parameters. my $doc = new XML::EasyOBJ('my_xml_document.xml'); makeNewNode( NEW_TAG ) Append a new element node to the current node. Takes the tag name as the parameter and returns the created node as a convienence. my $p_element = $doc->body->makeNewNode('p'); remapMethod( CUR_METHOD, NEW_METHOD ) Allows you to change the name of any of the object methods. You might want to do this for convienience or to avoid a naming collision with an element in the document. Two parameters need to be passed; the current name of the method and the new name. Returns 1 on a successful mapping and undef on failure. A failure can result if you don't pass two parameters if if the "copy from" method name does not exist. $doc->remapMethod('getString', 's'); $doc->s(); After remapping you must use the new name if you with to remap the method again. You can call the remapMethod method from any place in the XML tree and it will always change the method globally. In the following example $val1 and $val2 are equal: $doc->some_element->another_element->('getString', 's'); my $val1 = $doc->s(); $doc->remapMethod('s', 'getString'); my $val2 = $doc->getString(); getString( ) Recursively extracts text from the current node and all children element nodes. Returns the extracted text as a single scalar value. Expands entities based on if the -expref flag was supplied during object creation. extractText( ) Same as getString() but does not check the -expref flag. Included for compatability with inital version of interface. setString( STRING ) Sets the text value of the specified element. This is done by first removing all text node children of the current element and then appending the supplied text as a new child element. Take this XML fragment and code for example: <p>This elment has <b>text</b> and <i>child</i> elements</p> $doc->p->setString('This is the new text'); This will change the fragment to this: <p><b>text</b><i>child</i>This is the new text</p> Because the <b> and <i> tags are not text nodes they are left unchanged, and the new text is added at the end of the specified element. If you need more specific control on the change you should either use the getDomObj() method and use the DOM methods directly or remove all of the child nodes and rebuild the <p> element from scratch. Also see the addString() method. addString( STRING ) Adds to the the text value of the specified element. This is done by appending the supplied text as a new child element. Take this XML fragment and code for example: <p>This elment has <b>text</b></p> $doc->p->addString(' and elements'); This will change the fragment to this: <p>This elment has <b>text</b> and elements</p> getAttr( ATTR_NAME ) Returns the value of the named attribute. my $val = $doc->body->img->getAttr('src'); getTagName( ) Returns the tag name of the specified element. This method is useful when you are enumerating child elements and do not know their element names. foreach my $element ( $doc->getElement() ) { print $element->getTagName(); } setAttr( ATTR_NAME, ATTR_VALUE, [ATTR_NAME, ATTR_VALUE]... ) For each name/value pair passed the attribute name and value will be set for the specified element. remAttr( ATTR_NAME ) Removes the specified attribute from the current element. remElement( TAG_NAME, INDEX ) Removes a child element of the current element. The name of the child element and the index must be supplied. An index of 0 will remove the first occurance of the named element, 1 the second, 2 the third, etc. getElement( TAG_NAME, INDEX ) Returns the node from the tag name and index. If no index is given the first child with that name is returned. Use this method when you have element names that include characters that are not legal as a perl method name. For example: <foo> <!-- root element --> <bar> <foo-bar>test</foo-bar> </bar> </foo> # "foo-bar" is not a legal method name print $doc->bar->getElement('foo-bar')->getString(); getDomObj( ) Returns the DOM object associated with the current node. This is useful when you need fine access via the DOM to perform a specific function. BEGINNER QUICK START GUIDE
Introduction You too can write XML applications, just as long as you understand the basics of XML (elements and attributes). You can learn to write your first program that can read data from an XML file in a mere 10 minutes. Assumptions It is assumed that you are familiar with the structure of the document that you are reading. Next, you must know the basics of perl lists, loops, and how to call a function. You must also have an XML document to read. Simple eh? Loading the XML document use XML::EasyOBJ; my $doc = new XML::EasyOBJ('my_xml_document.xml') || die "Can't make object"; Replace the string "my_xml_document.xml" with the name of your XML document. If the document is in another directory you will need to specify the path to it as well. The variable $doc is an object, and represents our root XML element in the document. Reading text with getString Each element becomes an object. So lets assume that the XML page looks like this: <table> <record> <rec2 foo="bar"> <field1>field1a</field1> <field2>field2b</field2> <field3>field3c</field3> </rec2> <rec2 foo="baz"> <field1>field1d</field1> <field2>field2e</field2> <field3>field3f</field3> </rec2> </record> </table> As mentioned in he last step, the $doc object is the root element of the XML page. In this case the root element is the "table" element. To read the text of any field is as easy as navigating the XML elements. For example, lets say that we want to retrieve the text "field2e". This text is in the "field2" element of the SECOND "rec2" element, which is in the FIRST "record" element. So the code to print that value it looks like this: print $doc->record(0)->rec2(1)->field2->getString; The "getString" method returns the text within an element. We can also break it down like this: # grab the FIRST "record" element (index starts at 0) my $record = $doc->record(0); # grab the SECOND "rec2" element within $record my $rec2 = $record->rec2(1); # grab the "field2" element from $rec2 # NOTE: If you don't specify an index, the first item # is returned and in this case there is only 1. my $field2 = $rec2->field2; # print the text print $field2->getString; Reading XML attributes with getAttr Looking at the example in the previous step, can you guess what this code will print? print $doc->record(0)->rec2(0)->getAttr('foo'); print $doc->record(0)->rec2(1)->getAttr('foo'); If you couldn't guess, they will print out the value of the "foo" attribute of the first and second rec2 elements. Looping through elements Lets take our example in the previous step where we printed the attribute values and rewrite it to use a loop. This will allow it to print all of the "foo" attributes no matter how many "rec2" elements we have. foreach my $rec2 ( $doc->record(0)->rec2 ) { print $rec2->getAttr('foo'); } When we call $doc->record(0)->rec2 this way (i.e. in list context), the module will return a list of "rec2" elements. That's it! You are now an XML programmer! *start rejoicing now* PROGRAMMING NOTES
When creating a new instance of XML::EasyOBJ it will return an object reference on success, or undef on failure. Besides that, ALL methods will always return a value. This means that if you specify an element that does not exist, it will still return an object reference (and create that element automagically). This is just another way to lower the bar, and make this module easier to use. You will run into problems if you have XML tags which are named after perl's special subroutine names (i.e. "DESTROY", "AUTOLOAD"), or if they are named after subroutines used in the module ( "getString", "getAttr", etc ). You can get around this by using the getElement() method of using the remapMethod() method which can be used on every object method (except AUTOLOAD and DESTROY). AUTHOR
/COPYRIGHT Copyright (C) 2000-2002 Robert Hanson <rhanson@blast.net> This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
XML::DOM perl v5.10.0 2009-08-19 EasyOBJ(3pm)
All times are GMT -4. The time now is 02:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy