topic Re: Fill required empty spaces before a string with 0 in QlikView

Fill required empty spaces before a string with 0

haneeshmarella — Wed, 25 Nov 2020 16:16:04 GMT

Hi people,

The original time string showing up is in a string format. The left column showing up 'Original Time String' has 108, 236, 4456, 34523 which as the last 3,4,5 digits of the time format hhmmss which is also string. How can I get them in the desired time string of hhmmss where the blanks are filled with 0's to meet the hhmmss format.

For clear understanding, Ex. 108 means 00:01:08 which is 12:01:08 AM.

Please help.

Re: Fill required empty spaces before a string with 0

jwjackso — Thu, 14 Jun 2018 18:12:11 GMT

Try =Num([Original Time Strin],'000000')

Re: Fill required empty spaces before a string with 0

vishsaggi — Thu, 14 Jun 2018 18:14:38 GMT

Try this?

TimeChar:

LOAD *, Repeat(0, 6-Len(OrigTimeStr))&OrigTimeStr AS Len INLINE [

OrigTimeStr

108

236

4436

34523

];

Re: Fill required empty spaces before a string with 0

shiveshsingh — Thu, 14 Jun 2018 18:15:20 GMT

Try Num function

Num(Field,'000000')

Re: Fill required empty spaces before a string with 0

haneeshmarella — Thu, 14 Jun 2018 18:16:47 GMT

Awesome. Thank you Jerry.

Re: Fill required empty spaces before a string with 0

haneeshmarella — Thu, 14 Jun 2018 18:24:50 GMT

The below one worked, Nagaraju. Thank you for your response.

Num([Original Time Strin],'000000')

Re: Fill required empty spaces before a string with 0

haneeshmarella — Thu, 14 Jun 2018 18:24:59 GMT

Thank you.