Search Results

You changed your sample data after I posted a potential solution. Try this below it should work on the new sample data:

awk '/>select[[:space:]]*$/{f++};/^from/{f && f--}f' xmlfile|awk -F"[<>]"...