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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156