Hi
I know many USA BC users use floatrates.com (we do the same). But I wonder if we can use website such as https://www.fx-exchange.com/usd/rss.xml
The rss link output is like below and I have following challenges here
1) Getting currency code. What is transformation rule look like to get the currency from " <title>US Dollar(USD)/United Arab Emirates Dirham(AED)</title>" I mean each line length change and I cannot code it to get to AED in this example. I do not know the code that tell the system to start from 2 characters from end of the line and go back 3.
2) Seems like publish date is text. Which transform rule can change this from text to date "<pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>"
3) How to tell system to get the currency rate from this line? What is the rule? "<description>1 US Dollar = 3.673 United Arab Emirates Dirham</description>"
Thanks
<?xml version="1.0" encoding="utf-8"?>
<channel>
<title>US Dollar(USD) Currency Exchange Rates</title>
<description>The latest currency exchange rates for US Dollar(USD)</description>
<lastBuildDate>Wed Mar 9 2022 15:21:54 UTC </lastBuildDate>
<language>en</language>
<copyright>Copyright© 2022 Currency Exchange Rates, www.fx-exchange.com/ </copyright>
<ttl>15</ttl>
<item>
<title>US Dollar(USD)/United Arab Emirates Dirham(AED)</title>
<pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>
<description>1 US Dollar = 3.673 United Arab Emirates Dirham</description>
<category>US Dollar</category>
</item>
<item>
<title>US Dollar(USD)/Netherlands Antillean Guilder(ANG)</title>
<pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>
<description>1 US Dollar = 1.8026 Netherlands Antillean Guilder</description>
<category>US Dollar</category>
</item>
<item>
<title>US Dollar(USD)/Argentine Peso(ARS)</title>
<pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>
<description>1 US Dollar = 108.678 Argentine Peso</description>
<category>US Dollar</category>
</item>
<item>
<title>US Dollar(USD)/Australian Dollar(AUD)</title>
<pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>
<description>1 US Dollar = 1.3645 Australian Dollar</description>
<category>US Dollar</category>
15,433
