I was unable to find an answer to my question after browsing some promising titles so I figured I would try my luck!
I'm attempting to extract information from XML files generated from a back-end we use at work. The information is not formatted like a normal XML document, so it's been a little difficult to extract what I need. I'm hoping that I can eventually put this information in a table, but I'll be happy if I can at least extract the values.
An example string is as follows:
<Event Name="Last Reef" VenueName="Theater" EventDate="2014-03-21 15:00:00" DirectLink="https://tickets.ctsciencecenter.org/Public/loader.asp?target=hall.asp?event=45259"/>
And I'm trying to get:
Event Name:
Venue Name:
Event Date:
Direct Link:
I'm assuming I need to use substr, but I've never dealt with a string like this.
If you take a moment to look at this, I would greatly appreciate it!