Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rss xml news feeds (multiple) - standardize Date format

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])
;





1 Reply
Not applicable
Author

You can go to: Edit script/Web files

It will be more sample