topic Re: Filter out date from a text string in QlikView

Filter out date from a text string

Thu, 13 Feb 2014 21:51:40 GMT

Hi,

I have the follwoing text and I would like to filter out the dates if its possible ?

Iis it possible to use any function or loop the string ?

Regards mikael

M Hyensjö/UK/##May-31-2012 15:56##New request created A Forsberg/##May-31-2012 15:57##New request created M Hyenjö/##Jun-01-2012 08:34##Waiting for approval A Olsson#

Re: Filter out date from a text string

Colin-Albert — Thu, 13 Feb 2014 22:04:03 GMT

The Textbetween function can extract the data

Re: Filter out date from a text string

Thu, 13 Feb 2014 22:06:08 GMT

If the date are in different places depending on the text, how could I use that function ?

Re: Filter out date from a text string

simondachstr — Thu, 13 Feb 2014 22:29:12 GMT

This strongly depends on how systematic and clean your data will arrive. In your current example, I would approach it with using Subfield(string,'##') because '##' obviously serves as a delimiter.

If you are e.g. sure that Date will always be located after the first ## within the string, then use Subfield(string,'##',2).

If you're not sure, then try making a loop on all subfields using a logic like IsNull(Date(Subfield(string,'##'))).

Re: Filter out date from a text string

Colin-Albert — Fri, 14 Feb 2014 07:47:20 GMT

This thread has details for using textbetween

Separate text to columns, when between the text it's the "|" caracter