Grep the URL's embedded in XML file

Question

I'm trying to grep/sed from the following xml data:

<record 
address="11.800.96.10" name="_ldap._tcp.gc._msdcs.example.com" port="3268" target="aws-sit2.example.com" type="SRV"/>

I wanted to retrieve below information in below format:

address value, name value, port value

Each record will have a carriage return after one liner recorded values extracted. How do I achieve this?

How have you attempted to solve this problem on your own? Please include any relevant commands in your question. — oxr463, Jul 3, 2019 at 12:10

pLumo · Accepted Answer · 2019-07-03 12:07:05Z

1

For parsing XML, use an xml parser, e.g. xmlstarlet!

xmlstarlet sel -t -m '//record' \
  -v '@address' -o " " \
  -v '@name' -o " " \
  -v '@port' -n \
xmlfile

Change the separator after -o to your needs. Or use -n for newline.

answered Jul 3, 2019 at 12:07

pLumo

20.7k1 gold badge37 silver badges61 bronze badges

This doesn't make use of either sed, nor grep.
– oxr463
Jul 3, 2019 at 12:10
1

Using sed and/or grep is a really bad idea for parsing xml data.
– pLumo
Jul 3, 2019 at 12:16
In general I would agree, and maybe you should include this in your answer; but no mention is made of how this will be utilized.
– oxr463
Jul 3, 2019 at 12:21

Add a comment |

Pushpam Kumar · Accepted Answer · 2019-07-03 08:32:54Z

0

awk '{print $1", "$2", "$3}' | sed -e 's/[=]/ /g' -e 's/["]//g'
This should work fine

answered Jul 3, 2019 at 8:32

Pushpam Kumar

1131 gold badge2 silver badges10 bronze badges

Add a comment |

2 Answers 2