I have a Log file as follows:
===================================== REQUEST 03-09-2019 01:12:25.808599 REF:5001462 ========================================= <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <Service2> <Rqst> <MsgHdr> <Version>006</Version> <TimeGMT>2019090221123353</TimeGMT> </MsgHdr> </Rqst> </Service2> ===================================== RESPONSE 03-09-2019 01:12:27.434655 Ref:5001462 ========================================= <Service2><Resp><MsgHdr><Version>006</Version><TimeGMT>20190903011227</TimeGMT></MsgHdr></Resp></Service2>
There is a request and then a response. Any idea how it can be parsed? I would need the whole Request XML and Response XML in a single row as well as the request and response time. Both have the same Ref field.