Sponsored Content
Top Forums Shell Programming and Scripting AWK script to parse a data in a file Post 302674519 by dd_psg on Friday 20th of July 2012 02:07:09 AM
Old 07-20-2012
AWK script to parse a data in a file

Hi Unix gurus..

I have a file which has below data, It has several MQ Queue statistics;

Code:
QueueName= 'TEST1'
CreateDate= '2009-10-30'
CreateTime= '13.45.40'
QueueType= Predefined
QueueDefinitionType= Local
QMinDepth= 0
QMaxDepth= 0
QueueName= 'TEST2'
CreateDate= '2009-10-30'
CreateTime= '13.51.12'
QueueType= Predefined
QueueDefinitionType= Local
QMinDepth= 0
QMaxDepth= 6

My output should be as below, each queue details should be displayed in a single line delimited by space,

Code:
QueueName= 'TEST1' CreateDate= '2009-10-30' CreateTime= '13.45.40' QueueType= Predefined QueueDefinitionType= Local QMinDepth= 0 QMaxDepth= 0
QueueName= 'TEST2' CreateDate= '2009-10-30' CreateTime= '13.51.12' QueueType= Predefined QueueDefinitionType= Local QMinDepth= 0 QMaxDepth= 6

thanks in advance..

Last edited by Scott; 07-20-2012 at 05:03 AM.. Reason: Code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To parse through the file and print output using awk or sed script

suppose if u have a file like that Hen ABCCSGSGSGJJJJK 15 Cock ABCCSGGGSGIJJJL 15 * * * * * * : * * * . * * * : Hen CFCDFCSDFCDERTF 30 Cock CHCDFCSDHCDEGFI 30 * . * * * * * * * : * * :* : : . The output shud be where there is : and . It shud... (4 Replies)
Discussion started by: cdfd123
4 Replies

2. Shell Programming and Scripting

Help!!! Shell script to parse data file.

I am faced with a :confused: tricky problem to parse a data file ( May not be a tricky problem to the scripting guru's ). Here is what I am faced with. I have a file with multiple rows of data and the rows are not of fixed length. "|" is used as a delimiters for individual columns and each row... (3 Replies)
Discussion started by: yajaykumar
3 Replies

3. Shell Programming and Scripting

parse data using sh script

Hi, I am a newbie to unix/shell scripting and i have a question on how to parse a txt file using perl in a sh script. I have a txt file that contains hundreds of lines with data like this.... X, Y, Latitude, Longitude 1, 142, -38.000000, -91.000000, 26.348 2, 142, 60.000000, -90.000000,... (2 Replies)
Discussion started by: moonbaby
2 Replies

4. Shell Programming and Scripting

parse data between parenthesis using shell script

Hi I am using shell script and i need to parse the data between parenthesis.How do i do it using shell script. Ex: section(name). I want to extract name from the above string using shell script. (4 Replies)
Discussion started by: julie_s
4 Replies

5. Shell Programming and Scripting

Parse config file data to script variable

I have a script with few pre defined variables. Also have a config file. Something like this. # config file # Define Oracle User MOD1_TAG=abcde MOD2_TAG=xyzabc MOD3_TAG=def I need to parse the config file and have each of the value copied to different variables. Please suggest what... (1 Reply)
Discussion started by: souryadipta
1 Replies

6. Shell Programming and Scripting

awk : Filter a set of data to parse header line and last field of multiple same match.

Hi Experts, I have a data with multiple entry , I want to filter PKG= & the last column "00060110" or "00088150" in the output file: ############################################################################################### PKG= P8SDB :: VGS = vgP8SOra vgP8SDB1 vgP8S001... (5 Replies)
Discussion started by: rveri
5 Replies

7. Shell Programming and Scripting

awk to split and parse unpredictable data

data.txt: CRITICAL: iLash: 97.00%, SqlPlus: 99.00%. Warning/critical thresholds: 95/98% I need to pull only the disknames: iLash and SqlPlus The following command will only pull iLash: echo "CRITICAL: iLash: 97.00%, SqlPlus: 99.00%. Warning/critical thresholds: 95/98%" | awk -F":"... (7 Replies)
Discussion started by: SkySmart
7 Replies

8. Shell Programming and Scripting

awk script to parse case with information in two fields of file

The below awk parser works for most data inputs, but I am having trouble with the last one. The problem is in the below rules steps 1 and 2 come from $2 (NC_000013.10:g.20763686_20763687delinsA) and steps 3 and 4 come from $1 (NM_004004.5:c.34_35delGGinsT). Parse Rules: The header is... (0 Replies)
Discussion started by: cmccabe
0 Replies

9. Shell Programming and Scripting

awk parse result that match data from file

i run command that return this result,example : gigabitethernet2/2/4:NotPresent, gigabitethernet2/1/17:UP, gigabitethernet2/1/10:UP, gigabitethernet2/1/5:UP, gigabitethernet2/1/9:UP, gigabitethernet2/1/36:DOWN, gigabitethernet2/1/33:DOWN, gigabitethernet2/1/8:UP,... (19 Replies)
Discussion started by: wanttolearn1
19 Replies

10. Shell Programming and Scripting

awk , parse data from stacked columns

I am trying to rearrange stacked columns. Below is an excerpt of my data file: You can see there are two data columns stacked vertically. ITERATION ... (1 Reply)
Discussion started by: sav0
1 Replies
Bio::Tools::EUtilities::Summary::ItemContainerI(3pm)	User Contributed Perl Documentation   Bio::Tools::EUtilities::Summary::ItemContainerI(3pm)

NAME
Bio::Tools::EUtilities::Summary::ItemContainerI - abtract interface methods for accessing Item information from any Item-containing class. This pertains to either DocSums or to Items themselves (which can be layered) SYNOPSIS
# Implement ItemContainerI # $foo is any ItemContainerI (current implementations are DocSum and Item itself) while (my $item = $foo->next_Item) { # iterate through contained Items # do stuff here } @items = $foo->get_Items; # all Items in the container (hierarchy intact) @items = $foo->get_all_Items; # all Items in the container (flattened) @items = $foo->get_Items_by_name('bar'); # Specifically named Items ($content) = $foo->get_contents_by_name('bar'); # content from specific Items ($type) = $foo->get_type_by_name('bar'); # data type from specific Items DESCRIPTION
DocSum data, as returned from esummary, normally is a simple list of item-content-content_type groups. However, items can also contain nested data to represent more complex data (such as structural data). This interface describes the basic methods to generically retrieve the next layer of Item data. For convenience classes may describe more specific methods, but they should be defined in terms of this interface and it's methods. FEEDBACK
Mailing Lists User feedback is an integral part of the evolution of this and other Bioperl modules. Send your comments and suggestions preferably to one of the Bioperl mailing lists. Your participation is much appreciated. bioperl-l@lists.open-bio.org - General discussion http://www.bioperl.org/wiki/Mailing_lists - About the mailing lists Support Please direct usage questions or support issues to the mailing list: bioperl-l@bioperl.org rather than to the module maintainer directly. Many experienced and reponsive experts will be able look at the problem and quickly address it. Please include a thorough description of the problem with code and data examples if at all possible. Reporting Bugs Report bugs to the Bioperl bug tracking system to help us keep track the bugs and their resolution. Bug reports can be submitted via the web. https://redmine.open-bio.org/projects/bioperl/ AUTHOR Chris Fields Email cjfields at bioperl dot org APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _ next_Item Title : next_Item Usage : while (my $item = $docsum->next_Item) {...} Function : iterates through Items (nested layer of Item) Returns : single Item Args : [optional] single arg (string) 'flatten' - iterates through a flattened list ala get_all_DocSum_Items() get_Items Title : get_Items Usage : my @items = $docsum->get_Items Function : returns list of, well, Items Returns : array of Items Args : none get_all_Items Title : get_all_Items Usage : my @items = $docsum->get_all_Items Function : returns flattened list of all Item objects (Items, ListItems, StructureItems) Returns : array of Items Args : none Note : items are added top-down (similar order to using nested calls) in original list order. 1 2 7 8 Item - Item - Item - Item ... | | 3 6 ListItem - ListItem | | 4 5 Structure - Structure get_all_names Title : get_all_names Usage : my @names = get_all_names() Function : Returns an array of names for all Item(s) in DocSum. Returns : array of unique strings Args : none get_Items_by_name Title : get_Items_by_name Usage : my @items = get_Items_by_name('CreateDate') Function : Returns named Item(s) in DocSum (indicated by passed argument) Returns : array of Item objects Args : string (Item name) get_contents_by_name Title : get_contents_by_name Usage : my ($data) = $eutil->get_contents_by_name('CreateDate') Function : Returns content for named Item(s) in DocSum (indicated by passed argument) Returns : array of values (type varies per Item) Args : string (Item name) get_type_by_name Title : get_type_by_name Usage : my $data = get_type_by_name('CreateDate') Function : Returns data type for named Item in DocSum (indicated by passed argument) Returns : scalar value (string) if present Args : string (Item name) perl v5.14.2 2012-03-02 Bio::Tools::EUtilities::Summary::ItemContainerI(3pm)
All times are GMT -4. The time now is 01:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy