topic rss xml news feeds (multiple) - standardize Date format in QlikView https://community.qlik.com/t5/QlikView/rss-xml-news-feeds-multiple-standardize-Date-format/m-p/181391#M47439 <HTML><HEAD></HEAD><BODY><P>You can go to: Edit script/Web files</P><P>It will be more sample</P></BODY></HTML> Fri, 31 Dec 2010 11:25:49 GMT 2010-12-31T11:25:49Z rss xml news feeds (multiple) - standardize Date format https://community.qlik.com/t5/QlikView/rss-xml-news-feeds-multiple-standardize-Date-format/m-p/181390#M47438 <HTML><HEAD></HEAD><BODY><P>I am developing an application and would like to include a simple RSS news reader with various feeds. Works great except the <STRONG>pubDate</STRONG> from each feed is in a different format. How can I standardize? (ex: M/D/YYYY h:mm:ss)</P><P>For example in each of these the pubDate is formatted differently</P><UL><LI><A href="http://feeds.reuters.com/reuters/technologyNews?format=xml">http://feeds.reuters.com/reuters/technologyNews?format=xml</A></LI><LI><A href="http://news.cnet.com/2547-1001_3-0-5.xml">http://news.cnet.com/2547-1001_3-0-5.xml</A></LI></UL><P>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...</P><P>Ex:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><BR /><B><BR />LOAD<BR /></B><B><BR /><BR /></B><BR /> 'Reuters Technology News' <B>as</B> Source<BR />,<BR />title<BR /><BR /><BR />,<BR />description<BR /><BR /><BR />,<BR />link<BR /><BR /><BR />,<BR />pubDate<B><BR />FROM<BR /></B><B><BR /><BR /></B><BR /> [http://feeds.reuters.com/reuters/technologyNews?format=xml] (XmlSimple, Table is [rss/channel/item])<BR />;<B><BR />CONCATENATE<BR /></B><BR />LOAD<B><BR /><BR /></B><BR /> 'CNET News' <B>as</B> Source<BR />,<BR />title<BR /><BR /><BR />,<BR />description<BR /><BR /><BR />,<BR />link<BR /><BR /><BR />,<BR />pubDate<B><BR />FROM<BR /></B><B><BR /><BR /></B><BR /> [http://news.cnet.com/2547-1001_3-0-5.xml] (XmlSimple, Table is [rss/channel/item])<BR />;<BR /><BR /><BR /><BR /></PRE><BR /><BR /> <P></P></BODY></HTML> Tue, 08 Jun 2010 20:37:53 GMT https://community.qlik.com/t5/QlikView/rss-xml-news-feeds-multiple-standardize-Date-format/m-p/181390#M47438 2010-06-08T20:37:53Z rss xml news feeds (multiple) - standardize Date format https://community.qlik.com/t5/QlikView/rss-xml-news-feeds-multiple-standardize-Date-format/m-p/181391#M47439 <HTML><HEAD></HEAD><BODY><P>You can go to: Edit script/Web files</P><P>It will be more sample</P></BODY></HTML> Fri, 31 Dec 2010 11:25:49 GMT https://community.qlik.com/t5/QlikView/rss-xml-news-feeds-multiple-standardize-Date-format/m-p/181391#M47439 2010-12-31T11:25:49Z