need help in formatting using awk

Question

Input Data

<Device>
      <dev_name>00002</dev_name>
      <Storage_Group>
        <Group_Info>
          <group_name>N/A</group_name>
    </Device>
    <Device>
      <dev_name>000BC</dev_name>
         <Storage_Group>
        <Group_Info>
          <group_name>sg_optimized</group_name>
          <group_name>sg_metro-nonir</group_name>
          <group_name>sh_m4i-pr-ixcem-a02</group_name>
          <group_name>sh_m4i-pr-ixcem-a01</group_name>
    </Device>
    <Device>
      <dev_name>000BD</dev_name>
          <group_name>sg_optimized</group_name>
         <dev_count>1</dev_count>
          <sg_count>0</sg_count>

          <group_name>sg_metro-nonir</group_name>
          <group_name>sh_m4i-pr-ixcem-b01</group_name>
          <group_name>sh_m4i-pr-ixcem-b02</group_name>
    </Device>
    <Device>
      <dev_name>000BE</dev_name>
          <group_name>sg_optimized</group_name>
    </Device>

Output

00002 N/A
000BC sg_optimized sg_metro-nonir sh_m4i-pr-ixcem-a02 sh_m4i-pr-ixcem-a01
000BD sg_optimized sg_metro-nonir sh_m4i-pr-ixcem-b01 sh_m4i-pr-ixcem-b02
000BE sg_optimized

I was using this but it only prints last group name. skipping ealier group name.

VMAX_TDEV_SG_EXTRACT () {
cat $TMPLOGDIR/tdevsg.m4i-pr-llpmax-a01.map |awk '
function vmax_tdev_sg_extract(DEV_NAME,SG_NAME) {
        print DEV_NAME,SG_NAME;
}
BEGIN {
  FS = "[<>/]" ;
}
{
if ($0 ~ /dev_name>/) {
vmax_tdev_sg_extract(DEV_NAME,SG_NAME);
DEV_NAME = $3
SG_NAME=""
}
if ($0 ~ /\ygroup_name>\y/)  { SG_NAME=$3 }
}
END {vmax_tdev_sg_extract(DEV_NAME,SG_NAME)}
'
}

I really hope there are copy/paste errors in that input file, and that's not what's really being generated — Chris Davies
– Chris Davies, Commented Sep 18, 2021 at 23:01
And broke the XML as you went - for example you have <Storage_Group> but no </Storage_Group> — Chris Davies
– Chris Davies, Commented Sep 19, 2021 at 14:07
yes my bad on that. But Below logic given Ed is considering "dev_name" and "group_name" which is good enough. the only issue what I found is below line do not exist. <group_name>N/A</group_name> . I tried replicating same logic for different pattern where I have this scenario. It is taking previously read variable printing. But for storage group either something exist or "N/A" which is working great. — Anesh Kumar
– Anesh Kumar, Commented Sep 20, 2021 at 3:52
I thought of wrapping up the existing one and come back to that scenario later. — Anesh Kumar
– Anesh Kumar, Commented Sep 20, 2021 at 3:55

Ed Morton · Accepted Answer · 2021-09-17 00:15:22Z

awk '
    BEGIN { FS="[<>]" }
    $2 == "dev_name"   { prt(); name = $3 }
    $2 == "group_name" { groups[++numGroups] = $3 }
    END { prt() }

    function prt(       i) {
        if ( name != "" ) {
            printf "%s%s", name, OFS
            for (i=1; i<=numGroups; i++) {
                printf "%s%s", groups[i], (i<numGroups ? OFS : ORS)
            }
            numGroups = 0
        }
    }
' file
00002 N/A
000BC sg_optimized sg_metro-nonir sh_m4i-pr-ixcem-a02 sh_m4i-pr-ixcem-a01
000BD sg_optimized sg_metro-nonir sh_m4i-pr-ixcem-b01 sh_m4i-pr-ixcem-b02
000BE sg_optimized

Stack Exchange Network

need help in formatting using awk

Input Data

Output

1 Answer 1

You must log in to answer this question.

Hot Network Questions

need help in formatting using awk

Input Data

Output

1 Answer 1

You must log in to answer this question.

Related

Hot Network Questions