topic Re: Text parsing for timestamp in QlikView

Text parsing for timestamp

antonaks — Thu, 21 Jun 2018 11:17:36 GMT

Hi colleagues.

I have string field with time stamp and some text.

For example:

21/06/2018 2:17: 6718 call Step_11

21/06/2018 2:59: 2461 call Step_12

21/06/2018 2:59: 2463 CALL Step1

21/06/2018 2:59: 6502 call Step_22

21/06/2018 2:59: 6503 call Step_23

21/06/2018 2:59: 6504 call Step_23

21/06/2018 3:00: 2464 CALL Step2

I what get timestamp, but don't wan't use Left() function, or something like that. I want use only timestamp#() if it possible.

Can you help me?

Re: Text parsing for timestamp

sunny_talwar — Thu, 21 Jun 2018 11:20:34 GMT

TimeStamp and Text are in the same column or are they two different columns?

Re: Text parsing for timestamp

antonaks — Thu, 21 Jun 2018 11:24:34 GMT

All In one column.

Re: Text parsing for timestamp

sunny_talwar — Thu, 21 Jun 2018 11:28:07 GMT

In that case, you need to separate out TimeStamp from the whole string before you can use TimeStamp#() function. You didn't want to use Left() function, but how about SubField to separate text from timestamp?

Re: Text parsing for timestamp

antonaks — Thu, 21 Jun 2018 11:41:38 GMT

I will try.

I thought we can use timestamp# with format like 'MM/DD/YYYY hh:mm####' to cut redundant text.

Re: Text parsing for timestamp

sunny_talwar — Thu, 21 Jun 2018 11:45:10 GMT

I don't think that is possible (atleast based on my understand)... you can help interpret an exact timestamp (not read as timestamp), but it cannot remove any untended text.

Re: Text parsing for timestamp

sunny_talwar — Thu, 21 Jun 2018 11:47:37 GMT

This works... if you are okay with using SubField

Table:

LOAD *,

TimeStamp(TimeStamp#(SubField(FieldName, ' ', 1), 'DD/MM/YYYY h:mm: ffff')) as TimeStamp;

LOAD * INLINE [

FieldName

21/06/2018 2:17: 6718 call Step_11

21/06/2018 2:59: 2461 call Step_12

21/06/2018 2:59: 2463 CALL Step1

21/06/2018 2:59: 6502 call Step_22

21/06/2018 2:59: 6503 call Step_23

21/06/2018 2:59: 6504 call Step_23

21/06/2018 3:00: 2464 CALL Step2

];

Re: Text parsing for timestamp

antonaks — Thu, 21 Jun 2018 11:58:36 GMT

Yes it works, thank you.

Re: Text parsing for timestamp

sunny_talwar — Thu, 21 Jun 2018 12:02:31 GMT

Awesome, please close the thread if you got what you wanted.

Best,

Sunny