Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am developing an application and would like to include a simple RSS news reader with various feeds. Works great except the pubDate from each feed is in a different format. How can I standardize? (ex: M/D/YYYY h:mm:ss)
For example in each of these the pubDate is formatted differently
To build the script I use the File Wizard (Web File), specify URL, and then edit to just get what I need. I imagine it is some kind of date formatting...
Ex:
LOAD
'Reuters Technology News' as Source
,
title
,
description
,
link
,
pubDate
FROM
[http://feeds.reuters.com/reuters/technologyNews?format=xml] (XmlSimple, Table is [rss/channel/item])
;
CONCATENATE
LOAD
'CNET News' as Source
,
title
,
description
,
link
,
pubDate
FROM
[http://news.cnet.com/2547-1001_3-0-5.xml] (XmlSimple, Table is [rss/channel/item])
;
You can go to: Edit script/Web files
It will be more sample