Hello.
I am trying to parse an XML string into separate columns. Below is the XML .
<tracking_data tracking_data_site='03063' seq_no='426' mpe_id='DSM-1' softwareversion='' run_start='08-01-2018 17:00:00' sortplan_1='' mpesortplanname_1='Dorap18' operation_1=''
>
<MailPiece Timestamp="08-01-2018 00:46:36.000" USPSdate="2018_03_20_t3" Result="Missent" MODSrun="3" Operation="222" IU="4" IUname="FSD" DU="257" DUname="CH-565" DST="257" DSTname="CH-565" Tray="37" IUtype="Unmanned" IDtype="Unknown" MDev="4" MDevName="FSD" MReason="4" MReasonName="Singulation Problem" Operation_no="222" SpecServiceCode_1="4202006699989401915901057903319581"/>
</tracking_data>
For example I want to extract the fields from the XML string to look like this:
tracking_data_site |
seq_no |
mpe_id |
03063 |
426 |
DSM-1 |
Is there a more simplified way of doing this besides using left, mid or right string functions?