Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm new with Qlikview and just started learning to use some regular expressions etc. I'm building my own social dashboard (with the QVsource connectors). All looks/goes well, ecxept for one thing:
When I load a search with the Twitter conector, I receive a colom called 'created_at' containing a timestamp with the following format:
Fri, 06 Apr 07:45:47 +0000
I tried to create a selection-table with it by selecting the field and changing the format into date, but nothing happens. How can I extract a selection-table with only the days or months?
Can anyone help me out?
Regards,
Sebastian
Found this elsewhere on the forum
=Timestamp(Date#(SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 2) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 3) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 6) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 4), 'MMMDDYYYYhh:mm:ss'))