Shell Programming and Scripting

Thanks for help to date - its been very useful

One more snag... another possible xml file I have to parse contains something like this..

I need to get the Acc total for each sub account id..
ie. there are 3 sub accounts but the tags are the same... what can I do here?

<RecSubaccs>

<RecSubacc>
<SubaccId>1</SubaccId>
<RecAccTotal>0</RecAccTotal>
</RecSubacc>

<RecSubacc>
<SubaccId>2</SubaccId>
<RecAccTotal>0</RecAccTotal>
</RecSubacc>

<RecSubacc>
<SubaccId>3</SubaccId>
<RecAccTotal>0</RecAccTotal>
</RecSubacc>

</RecSubaccs>

You could also use CPAN (XML::pick_one): Stepping up from XML::Simple to XML::LibXML

Code:

awk -v v=SubaccId -F'[<|>]' '$2==v{s=$3;getline;a[s]+=$3}END {for (i in a)print v,i,a[i]}'   file

Next time please start a new topic for your new question.

I asked this question in same thread as I need to do this in the same script and its a sub-question..

Can you tell me how I do this within the same script so I can still get the name, add etc but also get the subtotals for each of the sub accounts...

ie. I need to be able to echo account, name, add, subtotal1, subtotal2 and subtotal3

How can I do this?

This code worked for me - can you explain the awk code and what its doing at each step so I can understand this?

Can you tell me how I need to modify this if there are more fields in the xml response?

ie. if there was additional information in a different response as below in red what do I need to change in the awk code?



<RecSubaccs>

<RecSubacc>
<SubaccId>1</SubaccId>
<RecAccTotal>0</RecAccTotal>
<RedAccType>Perm</RedAccType>
</RecSubacc>

<RecSubacc>
<SubaccId>2</SubaccId>
<RecAccTotal>0</RecAccTotal>
<RedAccType>Perm</RedAccType>
</RecSubacc>

<RecSubacc>
<SubaccId>3</SubaccId>
<RecAccTotal>0</RecAccTotal>
<RedAccType>Temp</RedAccType>
</RecSubacc>

</RecSubaccs>

I'll try:

Code:

# cat awk.file
BEGIN{
      FS="[<|>]"     # Set Field Separator
      v="SubaccId"   # Set v value, the search pattern
      }
$2==v{               # If second field equal v...
      s=$3           # Set assign third field value to s variable
      getline        # Read next line
      a[s]+=$3       # Build the a array with the s elements and sum of third field
      }
END{                 # At the end do....
    for (i in a)     # For each element of a array do..
    print v, i, a[i] # Print v (static pattern) and i (array element) and i array value.
   }

and run the code as:

Code:

awk -f awk.file data.file

and please start a new topic for your new question!