UNIX for Advanced & Expert Users

<SOURCE BUSINESSNAME ="" DATABASETYPE ="Teradata" DBDNAME ="DWPROD3" DESCRIPTION ="" NAME ="ACTRL_BNFT_KEY_DMN" OBJECTVERSION ="1" OWNERNAME ="COC_V20_ETL_APPL" VERSIONNUMBER ="1">
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="varchar" DESCRIPTION ="" FIELDNUMBER ="1" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" </SOURCE>

SOURCE ->ACTRL_BNFT_KEY_DMN

#!/bin/bash

F=0
while read line
do
        [[ ! "$line" =~ ^\<SOURCE[[:space:]] ]] && continue

        for attr in $line
        do
                if [[ "$attr" =~ ^NAME$ ]]
                then
                        F=1
                        continue
                fi
                if [ $F -eq 1 ]
                then
                        attr="${attr%\"*}"
                        printf "SOURCE -> %s\n" "${attr#*\"}"
                        F=0
                fi
        done

done < file.xml

awk '$1=="<SOURCE"{for(i=1;i<=NF;i++){if($i=="NAME"){gsub(/=|"/,x,$(i+1)); print "SOURCE -> " $(i+1)}}}' file.xml