Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Assign zero to strings that don't appear in block, store result in AWK array
Top Forums Shell Programming and Scripting Assign zero to strings that don't appear in block, store result in AWK array Post 302567169 by Ophiuchus on Saturday 22nd of October 2011 07:31:37 PM
Old 10-22-2011
Assign zero to strings that don't appear in block, store result in AWK array
Hi to all,

I have this input:
Code:
<group>                    
<x "2">Group D</x>
<x "3">Group B</x>
<x "1">Group A</x>
</group>                    
<group>                    
<x "1">Group E</x>
<x "0">Group B</x>
<x "1">Group C</x>
</group>                    
<group>                    
<x "3">Group C</x>
<x "2">Group B</x>
<x "7">Group A</x>
</group>

And I would like this output stored in an AWK array.
Code:
2|Group D
3|Group B
1|Group A
0|Group C
0|Group E
1|Group E
0|Group B
1|Group C
0|Group A
0|Group B
3|Group C
2|Group B
7|Group A
0|Group E
0|Group D

the unique Groups are
Code:
Group A
Group B
Group C
Group D
Group E

As you can see, some Groups could be in all blocks, but sometime one or more Groups appear only in some blocks.

For those Groups that don't appear in a specific block I need to generate an output that assign them zero value for that block as
shown for the groups in red.

I am able to get the output in the format "number|Group X" with the script below, but I don't know how to
add the groups that don't appear in a specific block and assign them zero value.
Code:
awk '/<x "/{A[1 + c++]=gensub(/(.+")([0-9]+)(">)(.+)(<\/.+)/, "\\2|\\4", "g")}
     END{for (i=1;i<=length(A);i++) print A[i]}' groups

I really need it in awk because I need that array to include it in a main AWK code.

Many thanks for your help in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to store query multiple result in shell script variable(Array)

:) Suppose,I have one table A. Table A have one column. Table A have 10 rows. I want this 10 rows store into shell script variable. like #!/bin/ksh v_shell_var=Hi here in call oracle , through loop How can I store table A's 10 rows into v_shell_var (Shell Script Array). Regards, Div (4 Replies)
Discussion started by: div_Neev
4 Replies

2. Shell Programming and Scripting

assign awk array with printf

I am trying to assign a awk array for further processing later in the script. I can't seem to figure it out. If someone could look at this and help me, I would very much appreciate it. Thanks in Advance. for ( x = 1 ; x <= Var ; x++ ) { if ( x in varr ) { ... (2 Replies)
Discussion started by: timj123
2 Replies

3. Shell Programming and Scripting

Prase a file and store and result to an array

Dear all, I have a file having the following formats: ThreadFail=Web1=1234 ThreadFail=Web2=2345 ThreadFail=Web3=12 ConnectionFail=DB1=11 ConnectionFail=DB2=22 The number of lines will be different from every time . How can I parse the file and store the result to an a array inside... (6 Replies)
Discussion started by: youareapkman
6 Replies

4. Shell Programming and Scripting

assign awk command result to a variable

#!/bin/sh # ## MYSTRING = `awk '/myApp.app/' /Users/$USER/Library/Preferences/loginwindow.plist` if then echo String not found defaults write /Users/$USER/Library/Preferences/loginwindow AutoLaunchedApplicationDictionary -dict-add -string Hide -bool YES -string Path -string... (9 Replies)
Discussion started by: dedmakar
9 Replies

5. Shell Programming and Scripting

awk assign output of array to specific field-number

With this script i want to print the output to a specific field-number . Can anybody help? awk 'NR=FNR{split(FILENAME,fn,"_");nr=$2;f = $1} END{for (i=1;i<=f;i++) print i,$fn=nr}' input_5.csv input_6.csvinput_5.csv 4 135 5 185 6 85 11 30input_6.csv 1 90 3 58 4 135 7 60 8 55 10... (1 Reply)
Discussion started by: sdf
1 Replies

6. Shell Programming and Scripting

Can -v option in awk be used to store an array of variables?

I want to pass an array of variables to be inserted by awk in the 2nd column of a file. Empl No. Employee Age 1000000 22 1100000 24 1200000 26 Now, I want to pass an array having three different ages which need to replace the... (7 Replies)
Discussion started by: Nishi_Licious
7 Replies

7. Shell Programming and Scripting

create an array which can store the strings from the user input in shell script

I want to create an array which can store the strings from the user input in shell script . example :- I want to store the 5 fruits name in a single array which the user provides . (1 Reply)
Discussion started by: Pkast
1 Replies

8. Shell Programming and Scripting

Store value in array with awk

Hi everybody I wanna store some values that r in a .txt file in some arrays for example I have: 32782 28 32783 02 32784 01 32785 29 32786 25 32787 25 32788 00 32789 25 32790 02 32791 29 32792 23 32793 01 32794 28 and I need to save the first... (4 Replies)
Discussion started by: Behrouzx77
4 Replies

9. Shell Programming and Scripting

How to Assign an shell array to awk array?

Hello All, Can you please help me with the below. #!/bin/bash ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5 EXTRACT_DT:30-SEP-12 VER_NUM:1" ARR="No Differences In Stage Between HASH_TOTALS & HASH_TOTALS_COMP For UNINUM:0722075 PROVIDER:5... (14 Replies)
Discussion started by: Ariean
14 Replies

10. Shell Programming and Scripting

Assign awk gsub result to a variable

Hello, I have searched but failed to find what exactly im looking for, I need to eliminate first "." in a output so i can use something like the following echo "./abc/20141127" | nawk '{gsub("^.","");print}' what i want is to use gsub result later on, how could i achieve it? Let say... (4 Replies)
Discussion started by: EAGL€
4 Replies

LEARN ABOUT SUNOS

exacct::object::group

Exacct::Object::Group(3PERL)				      Perl Library Functions				      Exacct::Object::Group(3PERL)

NAME

       Exacct::Object::Group - exacct group manipulation

SYNOPSIS

       use Sun::Solaris::Exacct::Object;
       my $ea_grp = Sun::Solaris::Exacct::Object::Group->new(
	  & EXT_GROUP | &EXC_DEFAULT | &EXD_GROUP_PROC);

DESCRIPTION

       This  module is used for manipulating libexacct(3LIB) Group objects. A libexacct Group object is represented as an opaque reference blessed
       into the Sun::Solaris::Exacct::Object::Group class, which is a subclass of the Sun::Solaris::Exacct::Object class. The Items within a Group
       are  stored  inside a Perl array. A reference to the array can be accessed with the inherited value() method. The individual Items within a
       Group can be manipulated with the normal Perl array syntax and operators. All  data  elements  of  the  array  must  be	derived  from  the
       Sun::Solaris::Exacct::Object class.  Group objects can also be nested inside each other simply by adding an existing Group as a data Item.

   Constants
       None.

   Functions
       None.

   Class methods
       Class methods include those inherited from the Sun::Solaris::Exacct::Object base class, plus the following:

       new($catalog, @objects)

	   This  method  creates  and  returns	a  new	Sun::Solaris::Exacct::Object::Group.  The  catalog  tag  can  be  either  an  integer or a
	   Sun::Solaris::Exacct::Catalog. The catalog tag should be a valid catalog tag for a Perl exacct Group object. The @objects parameter	is
	   a list of Sun::Solaris::Exacct::Object to be stored inside the Group. A copy of all the passed Items is taken and any Group objects are
	   recursively copied. The contents of the returned Group object can be accessed with the array returned by the value method.

   Object methods
       as_hash()

	   This method returns the contents of the group as a hash reference. It uses the string value of each item's catalog ID as the hash entry
	   key	and the scalar value returned by value() as the hash entry value. This form should be used if  there are no duplicate catalog tags
	   in the group.

	   This method and its companion as_hashlist() are the fastest ways to access the contents of a Group.

       as_hashlist()

	   This method returns the contents of the group as a hash reference. It uses the string value of each item's catalog id as the hash entry
	   key	and an array of the scalar values returned by value() as the hash entry value for all the items that share a common key. This form
	   should be used if there might be duplicate catalog tags in the group.

	   This method and its companion as_hash() are the fastest ways to access the contents of a Group.

   Exports
       None.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWpl5u			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Evolving			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       Exacct(3PERL),	Exacct::Catalog(3PERL),   Exacct::File(3PERL),	 Exacct::Object(3PERL),   Exacct::Object::Item(3PERL),	  libexacct(3LIB),
       attributes(5)

SunOS 5.10							    1 Dec 2002					      Exacct::Object::Group(3PERL)
All times are GMT -4. The time now is 10:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy