Hi
I know many US companies uses floatrates as exchange rate service. But I wonder if you can help me to setup fx-exchange.com for this purpose. This way since they support many currencies it can be used in many countries. Basically all user need to do is get the RSS for their currency and that is it.
the USD link is like this www.fx-exchange.com/.../rss.xml
The output is like below. My questions are
1) How I design transfer rule to get the currency code from this text? I mean the length of text can change based on the name. Is it any method that transfer rule start from character 2 at the end of the text and go back 3? "<title>US Dollar(USD)/United Arab Emirates Dirham(AED)</title>"
2) How to setup transfer rule to convert this text date to actual date? " <pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>"
3) How to setup transfer rule to get the currency rate from this info? " <description>1 US Dollar = 3.673 United Arab Emirates Dirham</description>"
<?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>
</item>