Parse XML data from Treasury.gov Website

[jmer]

Hi all,

I'm sure there may be an easy solution for this but I'm spinning my wheels. Below is a link to xml formatted data that I've been able to get to come through a download tool (workflow attached). What I can't figure out is how to parse or re-format this so it is in a table format like this picture attached. Can anyone point me in the right direction to configuring the xml parse tool or RegEx tool?

Data Link:

https://home.treasury.gov/resource-center/data-chart-center/interest-rates/pages/xml?data=daily_trea...

[PhilipMannering · Accepted solution]

Hey @jmer 

This is probably a good start,